Help me write a formula? IF, AND, MAX/MIN? I can't figure it out.

[leahflum]

Hello,
I hope you are well! Would you please help me?
I would like to program the following logic into a cell:
If cell B10 is less than 100, result is "1".
If cell B10 is greater than 100 but less than or equal to 380, result is "2".
If cell B10 is greater than 380 but less than or equal to 1500, result is "4".
If cell B10 if greater than 1500, result is "ERROR".
Is this possible to do in a single cell? Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=if(b10<=100,1,if(b10<=380,2,if(b10<=1500,4,"Error")))

 

[leahflum]

Hi & welcome to MrExcel.
How about

=if(b10<=100,1,if(b10<=380,2,if(b10<=1500,4,"Error")))

PERFECT! Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.