"If" function question
 

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!

"If" function question
 

Try

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

Hope this helps,

Hutch

"Gina" wrote:

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!

"If" function question
 

This was perfect. Thank you so much!

"Tom Hutchins" wrote:

Try

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

Hope this helps,

Hutch

"Gina" wrote:

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!

"If" function question
 

Hi,

Try:

=IF(E4NOW(),"",IF(E4=F4,,"Not ")&"Met")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Gina" wrote:

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!