| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then with Today formula
PERFECT!!! Thanks to everyone for the help!
"T. Valko" wrote: If it is under 200 I want it to display the value, but if over 200 I need it to show zero. What if the difference *is* 200? Try this: A1 = today =(B1-A1)*(B1-A1<200) -- Biff Microsoft Excel MVP "JimG" wrote in message ... Perhaps I am being dense but it isn't working. Here is a sample of what I have A1 B1 C1 3/21/2009 Request Date Days in Processing 1/1/2008 445 3/21/09 is Today() and the result is 445. If it is under 200 I want it to display the value, but if over 200 I need it to show zero. I appreciate the help "Sheeloo" wrote: =IF(A1-Today()250,A1-Today(),0) with date in A1... You can change the comparison according to your logic. "JimG" wrote: I am trying to subtract one date from another using the Today() formula, but if the value is greater than 250 I want to return the value of 0. Can someone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement containing today formula | Excel Worksheet Functions | |||
| TODAY formula | Excel Discussion (Misc queries) | |||
| Using today formula for a template | Excel Discussion (Misc queries) | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
| formula - Age today | Excel Worksheet Functions | |||
Threaded Mode
