- 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: Easy nested Excel "if" statement: Who can solve it?
Posted on 5/5/17 at 10:51 am to TheTideMustRoll
Posted on 5/5/17 at 10:51 am to TheTideMustRoll
quote:
I'm not an Excel programming expert, but my guess is that it's related to all of your parenthetical statements.
This
0
Posted on 5/5/17 at 4:06 pm to finchmeister08
quote:
this formula is basically a filter. the spreadsheet is basically an order form for windows, and i'm filtering out wall panel types for the correct jamb fin. i think the problem lays in each "if" statement. each "if" statement compares the "Windows!C33" cell to a different range each time.
why are you doing this in excel and not python where 2 lines of ode solves your problem?
Posted on 5/5/17 at 6:24 pm to CptBengal
Yeah, everyone knows how to code python!
Posted on 5/5/17 at 8:35 pm to finchmeister08
You'll get cross-eyed trying to put that all in one statement. Instead of nesting, create a column for each nested IF. Then create one more column to tie the others together.
Posted on 5/6/17 at 6:53 am to Bestbank Tiger
Stop using excel. Have your ETL guy create a view for you to query.
Page 3 of 3
Popular
Back to top
Follow TigerDroppings for LSU Football News