ExcelBanter - How do you do an IF statement in Excel comparing three columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you do an IF statement in Excel comparing three columns (https://www.excelbanter.com/excel-worksheet-functions/255106-how-do-you-do-if-statement-excel-comparing-three-columns.html)

How do you do an IF statement in Excel comparing three columns

If I want column D to equal the highest number from column A, B, or C how
would I write that formula?

Gary''s Student

How do you do an IF statement in Excel comparing three columns

In D1 enter:

=MAX(A1:C1)
and copy down
--
Gary''s Student - gsnu201001

"JB" wrote:

If I want column D to equal the highest number from column A, B, or C how
would I write that formula?

All times are GMT +1. The time now is 12:53 PM.