If statement

Posted on 2011-04-18
Medium Priority
Last Modified: 2012-05-11

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))
Question by:pdvsa
  • 2
LVL 33

Expert Comment

ID: 35419672
=IF(DropDownDate<>"","No Dropdown",YearsMonthsDays($A$8,$B$3,$M$4,$M$5))
LVL 33

Accepted Solution

jppinto earned 2000 total points
ID: 35419675
=IF(DropDownDate<>"",YearsMonthsDays($A$8,$B$3,$M$4,$M$5),"Dont use this Section")

Author Closing Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question