George Sanders37 said:So, if you have number X in cell A1 and number Y in cell B1, your formula in C1 would look like this:
=IF(A1>B1,A1,B1)
That should always spit out the larger number in cell C1.
edit: I guess this formula just checks which one is bigger. If both numbers are actually the same, you might want to use >= instead, so it'd be:
=IF(A1>=B1,A1,B1)
That way, if they're identical, it'll probably just grab whatever is in cell A1.
edit2:
I was talking to a buddy earlier and he reminded me about the MAX function. So, you could just put this in C1:
=MAX(A1,B1,.....)
The dots are just more cells, and the formula will always find the highest value in the set.
Thanks so much! That's exactly what I needed...