- 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 Please
Posted on 7/31/14 at 11:26 am
Posted on 7/31/14 at 11:26 am
Hey guys,
I already have a division formula set up for "Total Cost" and "Total Tons" in the "Cost/Ton ($)". What i want it to do next is if the "Checked?" cells are "Yes", i want the "Cost/Ton ($)" cell to divide by two.
this is what i have for cell L3
I already have a division formula set up for "Total Cost" and "Total Tons" in the "Cost/Ton ($)". What i want it to do next is if the "Checked?" cells are "Yes", i want the "Cost/Ton ($)" cell to divide by two.
this is what i have for cell L3
Posted on 7/31/14 at 11:28 am to finchmeister08
i would help, but it's not something i excel at
Posted on 7/31/14 at 11:29 am to finchmeister08
=IF(M3="YES",L3/2,"NO")
Posted on 7/31/14 at 11:29 am to finchmeister08
nvm
link's got it
link's got it
This post was edited on 7/31/14 at 11:30 am
Posted on 7/31/14 at 11:29 am to finchmeister08
=if(M2="Yes",sum(L2/2),L2)
Posted on 7/31/14 at 11:30 am to finchmeister08
NVM
This post was edited on 7/31/14 at 11:31 am
Posted on 7/31/14 at 11:31 am to finchmeister08
You can do an if statement inside of an if
=IF(M3="Yes", (J3/K3)/2, IF(K3=0,0,J3/K3))
ETA: It looks like the previous answers are referring to L column, which won't work since the cell is referencing itself.
ETA2: Or I just didn't understand where you wanted this answer put...
=IF(M3="Yes", (J3/K3)/2, IF(K3=0,0,J3/K3))
ETA: It looks like the previous answers are referring to L column, which won't work since the cell is referencing itself.
ETA2: Or I just didn't understand where you wanted this answer put...
This post was edited on 7/31/14 at 11:34 am
Posted on 7/31/14 at 11:31 am to finchmeister08
Got an excel power user in the building
Posted on 7/31/14 at 11:31 am to finchmeister08
Link has it right, but if the "Checked" cells are "No", what do you want the formula to do then? You have to have at least two conditions considered when using =IF.
This post was edited on 7/31/14 at 11:32 am
Posted on 7/31/14 at 11:34 am to Quidam65
if no, i just want it to divide the J3 and K3 cells.
Posted on 7/31/14 at 11:35 am to finchmeister08
Check my reply. I think it's what you want.
Posted on 7/31/14 at 11:36 am to Quidam65
checked cells don't have to say anything. the charged cells will remain "no" until the checked cells say "yes".
Posted on 7/31/14 at 11:37 am to ell_13
quote:
Check my reply. I think it's what you want.
yep, that's what i wanted. thanks, man.
Posted on 7/31/14 at 11:38 am to finchmeister08
sure no problem a-hole
Posted on 7/31/14 at 11:40 am to link
he wasn't looking for what to put into the "Checked" column. It was for the L column.
Posted on 7/31/14 at 11:42 am to finchmeister08
You need to switch around the 2 if statements if you want to avoid the Div/0 error when sold tons=0.
=IF(K3=0,0,IF(M3="Yes",(J3/K3)/2,J3/K3)) should do it.
=IF(K3=0,0,IF(M3="Yes",(J3/K3)/2,J3/K3)) should do it.
Posted on 7/31/14 at 11:42 am to ell_13
correct. i was wanting the $10 to be divided by 2 because this project was checked.
Posted on 7/31/14 at 11:43 am to finchmeister08
=IF(M3="No",(J3/K3),((J3/K3)/2))
ETA: What is your IF formula for M3? If the test function based off of results of L3?
ETA: What is your IF formula for M3? If the test function based off of results of L3?
This post was edited on 7/31/14 at 11:49 am
Posted on 7/31/14 at 11:43 am to Vandyrone
That's probably safer, but I was assuming the "Yes" would only be there if there was actually a value in K.
Popular
Back to top
Follow TigerDroppings for LSU Football News