View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian W. Ian W. is offline
external usenet poster
 
Posts: 3
Default 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