conditional statement to return greatest value
 

hello,
I have several colums containing numerical data. What Im trying to do do is
create another column that will return the highest value for each row. I've
fooled around with conditional statements to try and get this to work but
can't seem to figure it out. Does anyone have any ideas? I'd really appricate
any input. Thanks!
-Ian

example:
column1 column2 column3 "column trying to create"
1 3 8 8
6 2 4 6
5 7 2 7

conditional statement to return greatest value
 

MAX(A1:C1)
what's the issue here? I'm sure it's not that simple.
Charles

Ian W. wrote:
hello,
I have several colums containing numerical data. What Im trying to do do is
create another column that will return the highest value for each row. I've
fooled around with conditional statements to try and get this to work but
can't seem to figure it out. Does anyone have any ideas? I'd really appricate
any input. Thanks!
-Ian

example:
column1 column2 column3 "column trying to create"
1 3 8 8
6 2 4 6
5 7 2 7

conditional statement to return greatest value
 

Charles,
Thanks you very much. It actually was that simple.
Appricate your help.
Ian

"Die_Another_Day" wrote:

MAX(A1:C1)
what's the issue here? I'm sure it's not that simple.
Charles

Ian W. wrote:
hello,
I have several colums containing numerical data. What Im trying to do do is
create another column that will return the highest value for each row. I've
fooled around with conditional statements to try and get this to work but
can't seem to figure it out. Does anyone have any ideas? I'd really appricate
any input. Thanks!
-Ian

example:
column1 column2 column3 "column trying to create"
1 3 8 8
6 2 4 6
5 7 2 7