Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

If statement

Experts,

How can I change the following to
If DropDownDate is NOT ""  meaning that there is data in it the say "Dont use this Section", otherwise use the YearsMonthsDays($A$8,$B$3,$M$4,$M$5

=IF(DropDownDate="","No Dropdown",YearsMonthsDays($A$8,$B$3,$M$4,$M$5))
Avatar of jppinto
jppinto
Flag of Portugal image

=IF(DropDownDate<>"","No Dropdown",YearsMonthsDays($A$8,$B$3,$M$4,$M$5))
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

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
Avatar of pdvsa

ASKER

ahh I forgot the <> meant "not"...darn it!  thank you