| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Question about "Find" function in Edit menu | Excel Discussion (Misc queries) | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
![Gina[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
