- 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
re: Excel Help Please
Posted on 7/31/14 at 11:31 am to finchmeister08
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
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)