I keep getting a "FALSE" return on the following nested formula:
=IF(OR($Q$4=12,$Q$4=6,$R$4=4,$R$4=12),IF(OR($D16="rtu",$D16="ahu"),$AC16,IF($D16="Aa",$AG16,IF(OR($D16="spl",$D16="SHP",$D16="SWUD"),$AE16,""))))
I think it may have something to do with improper parenthesis use?
Any help would be appreciated.
What result do you expect and why? What do you think the formula should be doing?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I am expecting a empty blank cell, because none of the values in the first IF(OR) formula were true.
That doesn’t tell me what you think the formula does or what you want it to do. There are arguments after the first OR, and if any of them are met, they’ll cancel out the first OR.
So, once again, explain in words what you are trying to do.
None of the conditions in the first IF(OR) are true so it should skip to the "" and return a blank cell.
If any of the conditions in the first IF(OR) statement were true then it should look at the value of cell D16 and, depending on the value, it would return the value of cell AC16, AG16, or AE16.
The "" you have at the end of the formula is only if the final IF isn't true. If you want to return something if the first OR isn't true, enter it between the last 2 parentheses:
=IF(OR($Q$4=12,$Q$4=6,$R$4=4,$R$4=12),IF(OR($D16="rtu",$D16="ahu"),$AC16,IF($D16="Aa",$AG16,IF(OR($D16="spl",$D16="SHP",$D16="SWUD"),$AE16,""))),"1st OR not true")
Insert "" right before the last ")"
,$AE16,""))))
become
,$AE16,""))),"")
Quang PT
Thanks Gregb11 and bebo021999!
That worked!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks