IF Formula
 

I am trying to compare two cells to eachother and populate a third cell with
the number that is the GREATER of the two. (IF f26 is greater than G34,
populate m22 with value in f26; BUT if g34 is greater than f26, populate m22
with value in g34). Any suggestions?

IF Formula
 

On Jan 13, 10:17*am, CrazyConfused
wrote:
I am trying to compare two cells to eachother and populate a third cell with
the number that is the GREATER of the two. *(IF f26 is greater than G34,
populate m22 with value in f26; BUT if g34 is greater than f26, populate m22
with value in g34). *Any suggestions?

Assuming you compare column F & G, then put the function in column
M :

=IF(F1G1,F1,G1)

cmd MAX shall help
 

Hi,
if there are numbers in the cells, you can try following formula in M22:
=MAX(F26;G34)
If there is mixed content (text or numbers), following formula will help (as proposed similar shortly):
=IF(F26G34;F26;G34)
Regards,
Karsten



CrazyConfused wrote:

IF Formula
13-Jan-10

I am trying to compare two cells to eachother and populate a third cell with
the number that is the GREATER of the two. (IF f26 is greater than G34,
populate m22 with value in f26; BUT if g34 is greater than f26, populate m22
with value in g34). Any suggestions?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parsing the Querystring with Javascript
http://www.eggheadcafe.com/tutorials...ystring-w.aspx