IF Formula

[CrazyConfused]

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?

 

[Yanick]

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(F1>G1,F1,G1)

 

[Karsten Awizio]

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(F26>G34;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/tutorial...a-74de5cbeef13/parsing-the-querystring-w.aspx