troubleshoot Nested IF

I have this nested formula:

Please Login or Register  to view this content.

Max nested if = 7 right?

But i only have 6 here, why won't it work?... after i get the error prompt, it highlights the last ROW function..

Hi

I've got a feeling that the formula string is too long, not that there are too many IF statements. Try putting the last HLOOKUP into a cell on its own, and then reference that cell and see if it works.

rylo

I'm using it for a matrix/table, im trying to fit in all formulas in 1 cell, i'm not sure if i can fit the HLOOKUP on a separate cell. Won't excel prompt me that the formula is too long if it is? The prompt says "The formula you typed contains an error"

got it... just a little bit of rearranging and concatenating...

Please Login or Register  to view this content.