ExcelBanter - 2 if statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - 2 if statements (https://www.excelbanter.com/excel-programming/332723-2-if-statements.html)

Matthew Coady

2 if statements

I have a cell (cell C) that has an if statement in it. The statement is, if
cell A is greater than or equal to 15000 than this cell equals cell B. I also
want to put another if statement in that reads if cell B is greater than
15000 then this cell equals 15000.

=if(a1=15000,b1,0)
=if(b1=15000,15000,b1)

how can I put these 2 statements into 1 cell?

Matthew Coady

2 if statements

nevermind, I solved

Roman[_4_]

2 if statements

Depents on priorities of the decisions which is better for you:
=IF(A1=15000;B1;IF(B115000;15000))
or
=IF(B115000;15000;IF(A1=15000;B1))

You did not specify what if both A and B are less than 15000. Put that
after last argument.

[email protected]

2 if statements

Matthew,

Try this....

=IF(A3=15000,IF(B3=15000,15000,B3),0)

Is that what you are after ?
Donna

All times are GMT +1. The time now is 05:08 AM.