Forum Discussion
Solved
NESTED IF and AND formula help please
Hi Excel Gurus Its been a while since I worked on nested formulas and need help please. In cell E7 I want to say if cell E6=a percentage then go off and do xxx OR if D6=a percentage and e6=TM...
Perhaps
=IFERROR(IFS(E$6>0,B7*E$6,AND(E$6="TM",$D$6>0),CALCULATOR!$I18*CALCULATOR!$M15/CALCULATOR!$K15,AND(E$6="TM",$D$6="TM"),CALCULATOR!$I18*CALCULATOR!$M15/CALCULATOR!$K15-D7),0)
Perhaps
=IFERROR(IFS(E$6>0,B7*E$6,AND(E$6="TM",$D$6>0),CALCULATOR!$I18*CALCULATOR!$M15/CALCULATOR!$K15,AND(E$6="TM",$D$6="TM"),CALCULATOR!$I18*CALCULATOR!$M15/CALCULATOR!$K15-D7),0)
Thanks Hans that seems to have worked - I shall now go off and edit all the calculators that have already been set up with the different variances where my formula wasn't working. If I come into any problems I'll be back for extra help.
Thanks so much you are amazing.
Pam
Thanks so much you are amazing.
Pam