MS Excel Help
Mar 17, 2006 | 11:02 pm
#5
Original Poster
FlyerTalk Evangelist
Join Date: Jun 2005
Location: QLA
Programs: SBUX Gold
Posts: 14,508
Originally Posted by rar indeed
Have the contents of C1 be "=IF(A1>B1,A1,B1)" and so on for A2,B2,C2....
Mar 17, 2006 | 11:05 pm
#6
Join Date: Jan 2006
Location: Los Angeles
Programs: UA, AA
Posts: 4,039
Originally Posted by IceTrojan
Many thanks! Trying to decipher what that translates to... is it "If A1 is greater than B1, then A1, otherwise B1"?
Mar 17, 2006 | 11:14 pm
#7
Original Poster
FlyerTalk Evangelist
Join Date: Jun 2005
Location: QLA
Programs: SBUX Gold
Posts: 14,508
Originally Posted by rar indeed
Yeah, exactly. What the if() function does is it evaluates the first argument, let's say A1>B1, and if it's true, it outputs the value as the second argument, A1, and if it's false, it outputs the value as the third argument, B1.
Mar 17, 2006 | 11:34 pm
#8
Original Poster
FlyerTalk Evangelist
Join Date: Jun 2005
Location: QLA
Programs: SBUX Gold
Posts: 14,508
Originally Posted by rar indeed
=(a1+if(b1>c1,b1,c1)+if(d1>e1,d1,e1))
Mar 17, 2006 | 11:41 pm
#9
Join Date: Jan 2006
Location: Los Angeles
Programs: UA, AA
Posts: 4,039
Originally Posted by IceTrojan
The "+" didn't work... took a while, but realized that those have to be "," in the SUM argument. Still, thanks for leading me the right way.
Mar 18, 2006 | 12:05 am
#10
Original Poster
FlyerTalk Evangelist
Join Date: Jun 2005
Location: QLA
Programs: SBUX Gold
Posts: 14,508
Originally Posted by rar indeed
Odd, just tried it in Excel over here and it worked using +.
FT STRIKES AGAIN!
Mar 18, 2006 | 7:32 pm
#11
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.
=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.
Mar 18, 2006 | 7:35 pm
#12
Original Poster
FlyerTalk Evangelist
Join Date: Jun 2005
Location: QLA
Programs: SBUX Gold
Posts: 14,508
Originally Posted by cordelli
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.
=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.
) 
Good to know for next time.
Mar 18, 2006 | 9:38 pm
#14
FlyerTalk Evangelist
Join Date: May 1998
Location: Massachusetts, USA; AA 2.996MM & Plat Pro, DL 1MM, GM & Flying Colonel
Posts: 25,034
Originally Posted by IceTrojan
Another question: How do I ask for the sum of (ColA) + (higher of Col B or C) + (higher of Col D or E)?
=A1+max(B1,C1)+max(D1,E1)
You can do some pretty fancy things with IF, nesting one inside another if you have to, but there's usually a simpler way to do simple things.
Mar 19, 2006 | 4:48 pm
#15
Join Date: Aug 2005
Location: Orlando, FL, home of the biggest human trap built by a mouse!
Posts: 62
Just a side note... an excellent Excel reference, www.MrExcel.com