Formula Help

[MitchF770]

Hello, First Time Excel user here, 

I am trying to create a formula that checks a specific cell to test whether it is between certain numeric parameters and then fills another cell with either a fixed number or a calculation using the originally tested cell. 

A24=IFS(B4<=37000,"255",AND(B4>=37001,B4<=48000),255+(B4-37000)*0.075),(B4>=48001,B4<=90000),"1080")

the Bolded part of my formula works fine but i am not sure how to add more "between two number" style parameters

[#2]

Hi Mitch,

You can nest IF formula to solve this logic, something alongside of:
=IF(B4<=37000, 255,
IF(AND(B4>=37001, B4<=48000),255+(B4-37000)*0.075,
IF(AND(B4>=48001,B4<=90000),1080,,))

you can continue adding new IF statements instead of "value if false" arguement for 255 times I believe.

Hope this helps.

Rgds,
Branislav

[#3]

@MitchF770 

Hello, using you IFS function, you should have:

A24=IFS(B4<=37000,255,AND(B4>=37001,B4<=48000),255+(B4-37000)*0.075),(B4>=48001,B4<=90000),1080)

There is no need to apply  double quotes around numeric values in your formula

[#4]

@MitchF770 

Another variant

=MAX(255,MIN(1080,255+(B4-37000)*0.075))