If-then-else formula
 

In excel, I have three numbers in columns A,B, & C. In column D, I want a
formula that gives me the higher of the three numbers listed in columns A, B,
and C. For example, if the columns have 2, 4, and 3 respectively, I want the
column D formula to arrive at 4 as the correct answer. How do I do this?

If-then-else formula
 

=MAX(A1:C1)

HTH,
Elkar


"Malachi3" wrote:

In excel, I have three numbers in columns A,B, & C. In column D, I want a
formula that gives me the higher of the three numbers listed in columns A, B,
and C. For example, if the columns have 2, 4, and 3 respectively, I want the
column D formula to arrive at 4 as the correct answer. How do I do this?

If-then-else formula
 

In excel, I have three numbers in columns A,B, & C. In column D, I
want a formula that gives me the higher of the three numbers listed in
columns A, B, and C. ...

One way is to put this in D1 and copy down:
=MAX(A1:C1)

If-then-else formula
 

=MAX(A:C)
in D4


"Malachi3" wrote:

In excel, I have three numbers in columns A,B, & C. In column D, I want a
formula that gives me the higher of the three numbers listed in columns A, B,
and C. For example, if the columns have 2, 4, and 3 respectively, I want the
column D formula to arrive at 4 as the correct answer. How do I do this?