Thread: 2 if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Coady Matthew Coady is offline
external usenet poster
 
Posts: 3
Default 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?