software

In excel, I have three numbers in columns A,B, amp; 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?

=MAX(A1:C1)

HTH,
Elkarquot;Malachi3quot; wrote:

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

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

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

=MAX(A:C)
in D4quot;Malachi3quot; wrote:

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