pdvsa
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) )
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,
=IF(DropDownDate="","No Dropdown",YearsMonthsDays(
=IF(DropDownDate<>"","No Dropdown",YearsMonthsDays( $A$8,$B$3, $M$4,$M$5) )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ahh I forgot the <> meant "not"...darn it! thank you