The formula does not add all totals, h41 is not adding on k38 if cell e46 = yes
The formula does not add all totals, h41 is not adding on k38 if cell e46 = yes
Your formula does not look as if it's going to cope with what you have set up. It does not say what should happen for every combination of YES and NO.
I'm not going to try and back-engineer it 'cos it's obviously wrong, so please tall us what you want to happen if you have in those two cells in E (E44 & E46):
YES YES
YES NO
NO YES
NO NO
Is your profile up-to-date???
Last edited by AliGW; 07-17-2021 at 06:09 AM.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If e44 = no, e46 will be yes, if e44 = yes, e46 will be no
OK - so what do you want to happen (in WORDS or as a FORMULA) if:
E44=YES & E46=NO
E44=NO & E46=YES
I have to ask because your attempted formula is muddled, unfortunately.
Your attachment is .xlsx, therefore you are not using Excel 2003. Please update your profile, as requested. Thanks.
This may get you on the right track:
=IF(AND(E44="YES",E46="NO"),formula_A,IF(AND(E44="NO",E46="YES"),formula_B,""))
Last edited by AliGW; 07-17-2021 at 07:49 AM. Reason: Typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks