How to stipulate multiple function arguments using the 'IF' function

[jewel]

I need my spreadsheet to use one formula that uses multiple 'ifs' in 1 field. In plain words formula in A3 should read something like, if A2 is 100 to 220, then 40+ ((A2-100)/2); AND if A2 >= 220 then 100; AND if A2<=100 then 40. I can't figure out how to write the multiple functional arguments. Can someone please help? Thank you!

 

[facethegod]

I need my spreadsheet to use one formula that uses multiple 'ifs' in 1 field. In plain words formula in A3 should read something like, if A2 is 100 to 220, then 40+ ((A2-100)/2); AND if A2 >= 220 then 100; AND if A2<=100 then 40. I can't figure out how to write the multiple functional arguments. Can someone please help? Thank you!

try..


=LOOKUP(MAX(0,A2),{0;100;220},CHOOSE({1,2,3},40,40+ ((A2-100)/2),100))

 

[jewel]

try..


=LOOKUP(MAX(0,A2),{0;100;220},CHOOSE({1,2,3},40,40+ ((A2-100)/2),100))

You are brilliant! Thank you!