Avatar of vpopper
vpopper
Flag for United States of America asked on

I need help with an EXCEL Nested formula.

I have attached a file with my current formulas and need help altering them to work.

Please see attached instructions,

Thanks!
formula-neede.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
vpopper

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Shums Faruk

in F7:
=IF(OR(E7<>"",E8<>""),"",IF(AND(E6="(Yes)",E7=""),"Enter %",""))

Open in new window

In F8:
=IF(OR(E7<>"",E8<>""),"",IF(E6="(Yes)", "OR $",""))

Open in new window

Shaun Vermaak

F7
=IF(AND(E6="(YES)",AND(E7="",E8="")),"Enter %","")

Open in new window

F8
=IF(AND(E6="(YES)",AND(E7="",E8="")),"OR $","")

Open in new window

Rob Henson

Try these:

F7   =IF(OR(E6<>"(Yes)",E7<>"",E8<>""),"","Enter %")
F8   =IF(OR(E6<>"(Yes)",E7<>"",E8<>""),"","Or $")
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
vpopper

ASKER
Thank you everyone This one seems most simple and works well.