I need help with an EXCEL Nested formula.

vpopper
vpopper used Ask the Experts™
on
I have attached a file with my current formulas and need help altering them to work.

Please see attached instructions,

Thanks!
formula-neede.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Top Expert 2016
Commented:
Hi,

pls try
=IF(AND(E6="(Yes)",E7="",E8=""),"Enter %","")

Open in new window

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

Open in new window

Regards
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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 VermaakTechnical Specialist
Awarded 2017
Distinguished Expert 2018

Commented:
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 HensonFinance Analyst

Commented:
Try these:

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

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial