IF statement

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

Excel 97
Is it possible, using an "IF" statement, to compare the
results of two different cells and return the higher
value? Should I be using a different function??? Nothing
I am trying is working!!!! HELP!!!!
 
Kathy said:
Excel 97
Is it possible, using an "IF" statement, to compare the
results of two different cells and return the higher
value? Should I be using a different function??? Nothing
I am trying is working!!!! HELP!!!!
Click to expand...

Yes and Yes.

=IF(A1>B1,A1,B1)

=MAX(A1,B1)
 
Back
Top