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.