SUM of Dropdown Selection; ISBLANK Statement

[dasbear3]

Good Morning/Afternoon,

In L3, I have a dropdown list of dates by year (2005-2012).
The formula I want to use for Z3 will add 5 years to the current displayed date in L3.

Right now, I have that listed as =SUM(L3)+5, but want to nest an ISBLANK statement in there for when L3 does not have a selection.

I'm sure this is an easy solution, but I am having a hard time coming up with it.
[highlight]Thank you for your time![/highlight]

 

[1968rm]

=if(isblank(l3),"",l3+5)

 

[Jonmo1]

Try

=IF(L3>0,L3+5,"")

 

[dasbear3]

1968rm,

Thank you for such PROMPT feedback! This is perfect. :]

Have a great day.

 

[dasbear3]

jonmo1,

Your solution is great! I feel like I blinked and already had such excellent responses.

Thank you!!

 

[Jonmo1]

glad to help, thanks for the feedback.

 

[1968rm]

Same here!

glad to help, thanks for the feedback.