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

Last Comment

vpopper

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

3/14/2017

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.

Shums Faruk

3/14/2017

in F7:

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

In F8:

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

Shaun Vermaak

3/14/2017

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

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

Rob Henson

3/14/2017

Try these:

F7 =IF(OR(E6<>"(Yes)",E7<>"",E8<>""),"","Enter %")
F8 =IF(OR(E6<>"(Yes)",E7<>"",E8<>""),"","Or $")

vpopper

3/14/2017

ASKER

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