Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|