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
jsav Posts 2 Registration date Tuesday February 12, 2013 Status Member Last seen February 12, 2013 - Feb 12, 2013 at 03:16 PM
Related:
- IF statement errors and using multiple IF statements.
- How many if statements can you nest - Guide
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files at once - Guide
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
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.
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
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:
=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
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
jsav
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
Feb 12, 2013 at 03:16 PM
Feb 12, 2013 at 03:16 PM
Thank you very much for your help!!!!!!
