Greater than, less than for 3 objects

[MrsWillmore]

I'm trying to get my formula to work on 3 items,

between 12571 to 50270 returns 243
between 50271 to 125140 returns 124
over 125140 returns 110

I had tried using this, but obviously it returns a value for the 110 as it's already over 50271
=IF(J48<=50270,"243",IF(J48>=50271,"124",IF(J48>=125141,"110")))
should I be using an AND or OR and trying to get a greater than, less than on the 50271 to 125140? I'm really stuck and would love any advice you can help with.

 

[Fluff]

Try it like

=IF(J48<=50270,243,IF(J48<=12510,124,110))

 

[Joe4]

Try this:

=IF(J48>125140,110,IF(J48>=50271,124,IF(J48>=12571,243,"")))

 

[Joe4]

Try it like

=IF(J48<=50270,243,IF(J48<=12510,124,110))

Only issue with that is it also returns 243 for values less than 12571.

 

[Fluff]

Only issue with that is it also returns 243 for values less than 12571.

Yup, I was only correcting the OP's formula

 

[MrsWillmore]

Try it like

=IF(J48<=50270,243,IF(J48<=12510,124,110))

Thank you, worked a treat

 

[Joe4]

Do you ever have any values less than 12571?
If so, what do you want to happen in those instances?