IF Function for Multiple Conditions

[LtCmdrData]

I am trying to write an IF function based on 3 conditions. It will test the following (A3+B3)*.1 = answer. If the answer is less than 150 then display 150. If the answer is greater than 400 then display 400. If the answer is between 150 and 400 then display answer. I have tried a nested IF statement but I keep getting errors. Can someone please help me? Perhaps I need to go at it with a different formula? Thanks.

 

[mumps]

Try: =IF((A3+B3)*0.1<150,"150",IF((A3+B3)*0.1>400,"400",(A3+B3)*0.1))

 

[njimack]

=min(max(sum(a3:b3)/10,150),400)

 

[Eric W]

Or:

=MEDIAN(150,400,(A3+B3)*.1)

 

[LtCmdrData]

Thank you very much. This is what I needed. I just wish I could have gotten it on my own.