Is there a way to get around the rule that you can only nest seven formulas in one cell? If not, is there a better formula than an IF formula for the following situation?
e.g.
=IF(C36=2,"value1",IF(C36=3,"value2",IF(C36=4,"value3",...," "))))))))
I have a few conditions that I am not able to use at this time because I over the nesting limit so it gives me a formula error.
THanks!
Bookmarks