# IF statement errors and using multiple IF statements.

Solved/Closed
jsav Posts 2 Registration date Tuesday February 12, 2013 Status Member Last seen February 12, 2013 - Feb 12, 2013 at 10:32 AM
jsav Posts 2 Registration date Tuesday February 12, 2013 Status Member Last seen February 12, 2013 - Feb 12, 2013 at 03:16 PM
Hello,
I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it.

I am wondering if there is a way to remove an error from IF statements when they do not apply.

For example:
If I have the following formula to show if "DUP" is in a cell I would like it to do the following calculation:
=IF(B34="DUP",((ABS(G33-G34))/((G33+G34/2)))*100)
How do I remove the FALSE value when I use this formula when the "DUP" does not apply. Either blank or "N/A" in its place.

To build on this, my second question is. Can I include more in the formula such as if "DUP" use this formula, but if "MS" use this formula, if neither leave blank? Is it possible, and can you offer any suggestions.

I would really appreciate guidance on this if anyone is willing to help. I would really appreciate it!!! Thank you very much!!!
Related:

## 3 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 12, 2013 at 10:54 AM
Hi jsav,

To get a blank instead of `FALSE', please use this formula:

=IF(B34="DUP",((ABS(G33-G34))/((G33+G34/2)))*100,"")

For the next part of your question you can use nested ifs. You can read more about nested ifs from the below mentioned link:

http://office.microsoft.com/en-in/excel-help/if-HP005209118.aspx

Do reply with results.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 12, 2013 at 10:56 AM
Hi Jsav,

1.
The IF formula works as follows:
IF(Condition, condition met or true, condition not met or false)
So your formula could look like:
=IF(B34="DUP",ABS(G33-G34)/(G33+G34/2)*100,"")
or
=IF(B34="DUP",ABS(G33-G34)/(G33+G34/2)*100,"N/A")

2.
Excel 2003 supports up to 7 nested IF statements.
Your formula could look like: