# IF Function for Multiple Conditions

#### LtCmdrData

##### Board Regular
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.

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Try: =IF((A3+B3)*0.1<150,"150",IF((A3+B3)*0.1>400,"400",(A3+B3)*0.1))

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

Or:

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

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

Replies
4
Views
260
Replies
0
Views
127
Replies
9
Views
252
Replies
4
Views
136
Replies
12
Views
633

1,203,387
Messages
6,055,122
Members
444,763
Latest member
Jaapaap

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back