IF statement errors and using multiple IF statements.

[Solved/Closed]
Report
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
-
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
-
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!!!

3 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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:
=IF(B34="DUP",ABS(G33-G34)/(G33+G34/2)*100,IF(B34="MS",YOUR FORMULA,""))

I guess you really like brackets, sorry for removing the unnecessary ones.

Best regards,
Trowa
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013

Thank you very much for your help!!!!!!