FlyerTalk Forums
Page 1 of 3
1
2
3
Show 40 post(s) from this thread on one page

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   Travel Technology (https://www.flyertalk.com/forum/travel-technology-169/)
-   -   MS Excel Help (https://www.flyertalk.com/forum/travel-technology/538099-ms-excel-help.html)

IceTrojan Mar 17, 2006 10:54 pm
MS Excel Help
 
Let's see how diverse FT is @:-)

I have 2 columns of numbers, A and B...

How do I tell Excel to plug the higher number of A and B into column C?

rar indeed Mar 17, 2006 10:58 pm
Have the contents of C1 be "=IF(A1>B1,A1,B1)" and so on for A2,B2,C2....

IceTrojan Mar 17, 2006 10:59 pm
Another question: How do I ask for the sum of (ColA) + (higher of Col B or C) + (higher of Col D or E)?

rar indeed Mar 17, 2006 11:01 pm
=(a1+if(b1>c1,b1,c1)+if(d1>e1,d1,e1))

IceTrojan Mar 17, 2006 11:02 pm
Originally Posted by rar indeed
Have the contents of C1 be "=IF(A1>B1,A1,B1)" and so on for A2,B2,C2....
Many thanks! Trying to decipher what that translates to... is it "If A1 is greater than B1, then A1, otherwise B1"?

rar indeed Mar 17, 2006 11:05 pm
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"?
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.

IceTrojan Mar 17, 2006 11:14 pm
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.
Nice... thank you so much for your help! I owe you a drink in the AC ^

IceTrojan Mar 17, 2006 11:34 pm
Originally Posted by rar indeed
=(a1+if(b1>c1,b1,c1)+if(d1>e1,d1,e1))
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.

rar indeed Mar 17, 2006 11:41 pm
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.
Odd, just tried it in Excel over here and it worked using +.

IceTrojan Mar 18, 2006 12:05 am
Originally Posted by rar indeed
Odd, just tried it in Excel over here and it worked using +.
It must be my Excel (stupid MS!)... I wouldn't doubt it. Actually, the only reason I started learning how to use Excel was to keep track of my mileage....

FT STRIKES AGAIN! :cool:

cordelli Mar 18, 2006 7:32 pm
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.

IceTrojan Mar 18, 2006 7:35 pm
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.
Great... you post just as I'm done with my little project and straining my brain to include all my nested arguments (going in to the 4th level :eek: ) :p

Good to know for next time. :)

cordelli Mar 18, 2006 8:13 pm
Sorry, it's been a long busy day, first time on.

Efrem Mar 18, 2006 9:38 pm
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)?
Simpler than previously posted solution, using the MAX function that cordelli beat me to on the first question:

=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.

Invero Mar 19, 2006 4:48 pm
Just a side note... an excellent Excel reference, www.MrExcel.com


All times are GMT -6. The time now is 5:20 pm.
Page 1 of 3
1
2
3
Show 40 post(s) from this thread on one page


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.