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))
pdvsaProject financeAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
=IF(DropDownDate<>"",YearsMonthsDays($A$8,$B$3,$M$4,$M$5),"Dont use this Section")
0
 
jppintoCommented:
=IF(DropDownDate<>"","No Dropdown",YearsMonthsDays($A$8,$B$3,$M$4,$M$5))
0
 
pdvsaProject financeAuthor Commented:
ahh I forgot the <> meant "not"...darn it!  thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.