Nested IF and/or functions

[taffmorgan7274]

I have a problem wherein I have 3 different answers for whatever appears in a single cell.
The cell which is the target cell is AE13 and the function cell is AD3
In the first instance if AE13l is less than 121 then the target cell should return a sum of 720
In the next IF function, if AE31 >120 and <171 the sum returned should be 825
In the final IF function, if AE31 >220 the sum returned is 900
How can I achieve this in a single formula?

 

[kevin9999]

What if the target cell is between 171 and 220?

 

[taffmorgan7274]

What if the target cell is between 171 and 220?

I have completely buggered up my figures.
<120 would be 750
120-171 would be 825
170 to 220 would be 900

 

[kevin9999]

And over 220?

 

[taffmorgan7274]

And over 220?

It would remain at 900 because I don’t envisage it being any more than that. But if you could add it to >220 would be 975.

 

[kevin9999]

OK, try this in cell AD3:

=IFS(AE13<=120,750,AE13<=170,825,AE13<=220,900,AE13>220,975)

 

[taffmorgan7274]

OK, try this in cell AD3:

=IFS(AE13<=120,750,AE13<=170,825,AE13<=220,900,AE13>220,975)

That is splendid. Thank you very much.

 

[kevin9999]

You're welcome, and thanks for the feedback