- 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
9
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: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
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News