IF statement

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!!!!
 
G

Glenn Schwandt

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
If statements 2
IF statement not returning correct answer 3
Word macro that can call cells out of Excel for a find and replace 0
I'm John, My first post. 0
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Multiple arguments 3

Top