- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help: I don't even know what to call this...
Posted on 2/6/15 at 4:49 pm
Posted on 2/6/15 at 4:49 pm
1. is the number i have.
2. is how i'm getting that number.
how do i make 1. divide by 2 if it's supposed to be split?
2. is how i'm getting that number.
how do i make 1. divide by 2 if it's supposed to be split?
Posted on 2/6/15 at 4:55 pm to finchmeister08
nevermind thought you mean divide by the number 2
just make some extra columns and if, then that shite
just make some extra columns and if, then that shite
This post was edited on 2/6/15 at 4:57 pm
Posted on 2/6/15 at 5:01 pm to CE Tiger
Just nest another if.
ETA: Same assumption as CE
Or is that what you mean? Divide by the number 2?
ETA: Same assumption as CE
Or is that what you mean? Divide by the number 2?
This post was edited on 2/6/15 at 5:04 pm
Posted on 2/6/15 at 5:20 pm to LSUtigerME
i want it to divide by 2 as in split the cost in half.
eta: i've tried typing out different ways to get the formula to work, but it keeps giving me errors. what's is the formula?
eta: i've tried typing out different ways to get the formula to work, but it keeps giving me errors. what's is the formula?
This post was edited on 2/6/15 at 5:21 pm
Posted on 2/6/15 at 5:27 pm to finchmeister08
(if j2="yes",(I2/2),(I2))
Posted on 2/6/15 at 5:37 pm to finchmeister08
=if(G2>0, if(J2="Yes",(D2+E2+G2)/2,(D2+E2+G2)),if(J2="Yes",(D2+E2+F2)/2,(D2+E2+F2))
eta: I may be missing a closed parenthesis at the end...
eta: I may be missing a closed parenthesis at the end...
This post was edited on 2/6/15 at 5:41 pm
Posted on 2/6/15 at 5:54 pm to Htown Tiger
holy crap that worked. thanks man. you were missing that last parentheses, but hell, i ain't even worried about it.
Posted on 2/6/15 at 10:42 pm to finchmeister08
(no message)
This post was edited on 2/25/15 at 2:29 am
Posted on 2/8/15 at 3:02 pm to bigblake
Agreed. Personally, I would use an IF(AND... to make that equation simpler.
Posted on 2/8/15 at 3:49 pm to lynxcat
I don't see how AND is going to help you.
What you could do is just divide the original formula by:
IF(J2 = "yes", 2, 1)
This avoids the duplication of the (arbitrarily complex) true/false arguments as shown earlier but still lets you do it all in one formula. So the whole thing would be:
=IF(G2 > 0, D2 + E2 + G2, D2 + E2 + F2) / IF(J2 = "yes", 2, 1)
Better still?
=(D2 + E2 + IF(G2 > 0, G2, F2)) / IF(J2 = "yes", 2, 1)
What you could do is just divide the original formula by:
IF(J2 = "yes", 2, 1)
This avoids the duplication of the (arbitrarily complex) true/false arguments as shown earlier but still lets you do it all in one formula. So the whole thing would be:
=IF(G2 > 0, D2 + E2 + G2, D2 + E2 + F2) / IF(J2 = "yes", 2, 1)
Better still?
=(D2 + E2 + IF(G2 > 0, G2, F2)) / IF(J2 = "yes", 2, 1)
This post was edited on 2/8/15 at 3:55 pm
Posted on 2/8/15 at 7:08 pm to bigblake
quote:
One of the easier excel questions on TD. Normally it's some complex offset/match function that people ask about.
Yeah, the tricky part is nesting the IF statements and getting the parenthesis right. You can get cross-eyed trying to get that code just right.
Posted on 2/9/15 at 8:38 am to Spock's Eyebrow
quote:
=(D2 + E2 + IF(G2 > 0, G2, F2)) / IF(J2 = "yes", 2, 1)
This. Was coming in to say you can embed the IF statements into the formula to eliminate as much nesting.
Posted on 2/9/15 at 2:51 pm to Spock's Eyebrow
quote:
I don't see how AND is going to help you.
What you could do is just divide the original formula by:
IF(J2 = "yes", 2, 1)
This avoids the duplication of the (arbitrarily complex) true/false arguments as shown earlier but still lets you do it all in one formula. So the whole thing would be:
=IF(G2 > 0, D2 + E2 + G2, D2 + E2 + F2) / IF(J2 = "yes", 2, 1)
Better still?
=(D2 + E2 + IF(G2 > 0, G2, F2)) / IF(J2 = "yes", 2, 1)
Very nice. Yes, doe not look like AND helps like I thought it may. I was thinking of how you could do a combo of IF(AND(G2>0, J2="YES")... but I do not think it simplifies anything.
Popular
Back to top
Follow TigerDroppings for LSU Football News