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)
|