- 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:42 am to finchmeister08
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: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
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)