An alternative to IF formula

June 12th, 2009 by admin admin

If you have tried to use eight nested IF formula in a single cell, you will find that it does not work. Because the limit is 7 if in one cell. But that doesn’t mean there is nothing you could do. You can consider using the LOOKUP formula which can take in more than 7 conditions. See this LOOKUP page for more details.

Leave a Reply

You must be logged in to post a comment.