Link to home
Start Free TrialLog in
Avatar of vpopper
vpopperFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

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

Try these:

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

ASKER

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