Prev: Are macros inherently slow in Excel 2007
Next: Tracking history of Office files chronologically
From: Karsten on 13 Jan 2010 11:21
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/tutorials/aspnet/4bb0c33a-dc86-42d9-8d5a-74de5cbeef13/parsing-the-querystring-w.aspx
 | 
Pages: 1
Prev: Are macros inherently slow in Excel 2007
Next: Tracking history of Office files chronologically