2 if statements

[Guest]

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?

 

[Guest]

nevermind, I solved

 

[Roman]

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

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

 

[donna.gough]

Matthew,

Try this....

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

Is that what you are after ?
Donna