- 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
1
Posted on 7/31/14 at 11:51 am to link
Exactly. I thought I was wrong at first. Had to read it a few times.
Posted on 7/31/14 at 11:52 am to ell_13
quote:
That's probably safer, but I was assuming the "Yes" would only be there if there was actually a value in K.
Switching around the if statements allows the intent of his original if (to avoid the Div/0 error) to remain intact.
Posted on 7/31/14 at 11:55 am to Vandyrone
He'll still avoid it as along as there isn't a "Yes" in column M which there won't be anyway. If there is a "yes" then something has been ordered.
Posted on 7/31/14 at 11:56 am to ell_13
That's true.
Posted on 7/31/14 at 12:06 pm to Vandyrone
I do believe yours is more sound though. Mine is based on an assumption.
Posted on 7/31/14 at 12:13 pm to link
Already did
Posted on 7/31/14 at 12:16 pm to ell_13
Thanks guys for all the help.
Posted on 7/31/14 at 12:31 pm to finchmeister08
I would suggest making that yes/no cell a drop down menu to prevent any other entries that would invalidate the formula.
Posted on 7/31/14 at 1:20 pm to TigerFanatic99
oh it is, brother man.
Page 2 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News