Forum Discussion
Solved
Nested IF AND formula for a table of values
Hi Community! I need help on a nested IF AND formula. I have the first part correct with =IF(AND(B17=A1,B18=D2,B19="Monthly"),B3) where I have a separate table with values in A1, B2 & B3. I have ...
To make your NESTED IF statement less complicated and more dynamic, it is best to unpivot your data and maintain one single table reference (as long as the same parameters/information are shared). Here's an example of what I mean:
With this new setup, your complex NESTED IF statement is no longer needed and a simple SUMIFS statement can be used to return the right Fee figure you're looking for
SergeiBaklan Thank you! I like this because it allows me to keep the table in matrix form.
Much appreciated!
Nick
NJ_Bruno , glad to help.
