re: Easy nested Excel "if" statement: Who can solve it?

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?

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.