If statement

Posted on 2011-04-18
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
    LVL 33

    Expert Comment

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

    Accepted Solution

    =IF(DropDownDate<>"",YearsMonthsDays($A$8,$B$3,$M$4,$M$5),"Dont use this Section")

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now