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?
|