Choosing a cell with the greater number

M

Maddie

Column A has a list of numbers and Column B has a list of numbers. In column
C, I would like it to select the greater number from cell A or B. Can
somebody tell me how to formulate that? Thank you.
 
M

Maddie

Thank you, I've been racking my brains on this and it was so simple. You're
a lifesaver!
-Maddie
 
L

L. Howard Kittle

If I understand correctly, try this and pull down in column C.

=LARGE(A1:B1,1)

If you want the largest number from either column A or B then try this in
C1.

=LARGE(A1:B50,1)

HTH
Regards,
Howard
 
K

Ken

Maddie

Try, in column C (c1)

=max(a1:b1)

Copy down column c for a row by row determination of the greater of
column A or B.

Ken
 
K

Know Enough to be Dangerous

In cell C1, enter: =Max(A1,B1). Then, copy this formula down column C
as needed.
 
M

meh2030

Column A has a list of numbers and Column B has a list of numbers. In column
C, I would like it to select the greater number from cell A or B. Can
somebody tell me how to formulate that? Thank you.
Click to expand...

Try using the MAX function. For example, if you have a number in cell
A1 and another number in cell B1, place the following formula in cell
C1: =MAX(A1,B1). I think that this is what you are asking.
 
Top