I want the greater number of 2 cells to show in a separate cell

G

Guest

I'm sure this is a simple question, but I can't seem to find the answer...I
want the greater number of 2 cells to show in a separate cell
Example...
IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3
IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3

Thank you
 

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

Percentage difference calc that knows the largest figure 3
percentages 4
value based on count (equation question) 2
Sumif number is greater than a number but less than another number 2
I need a formula 2
Conditional Format Range of Cells 3
count cells in a document, but excude cells with a "0" 1
If statement with dates 0

Top