If-then-else formula

M

Malachi3

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?
 
M

MyVeryOwnSelf

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. ...
Click to expand...

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