"If" function question

[Gina]

I am working on a formula, but can not seem to get it right. This is what I
have so far:

=IF(F4<=E4,"Met","Not Met")

If the date in cell F4 is less than the date in cell E4, the goal was met.

What I'd like to add, is if the goal date in E4 is greater than NOW, I'd
like no value to be returned at all.

Can anyone help with this? I don't want my spreadsheet to light up like a
xmas tree that our targets haven't been met, when they're not due until a
future date.

Thanks!

 

[Tom Hutchins]

Try

=IF(E4>NOW(),"",IF(F4<=E4,"Met","Not Met"))

Hope this helps,

Hutch

 

[Gina]

This was perfect. Thank you so much!

Try

=IF(E4>NOW(),"",IF(F4<=E4,"Met","Not Met"))

Hope this helps,

Hutch

 

[Shane Devenshire]

Hi,

Try:

=IF(E4>NOW(),"",IF(E4>=F4,,"Not ")&"Met")