FlyerTalk Forums - View Single Post - MS Excel Help
Thread: MS Excel Help
View Single Post
Old Mar 18, 2006 | 7:32 pm
  #11  
cordelli
In Memoriam
 
Join Date: Feb 2000
Location: Easton, CT, USA
Programs: ua prem exec, Former hilton diamond
Posts: 31,801
That works, but here is also an easier way

=max(a1,b1)

it returns the max of any of the arguments there, and you can go as many cells as you need to.

You can do the same thing with the total clls.

For more then two columns, the max command is much easier then nesting if then's.
cordelli is offline