Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula take 3
Sorry for not explaining the problem better.
With the formula =INT((TODAY()-D10)/365.25); I get a value of "0" for the first year past todays date, and I can only have a max value of 4. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula take 3
So, what is your problem? Do you want 1 to be returned for the first
year? If so, add 1 to your formula. If you want to ensure that a number larger than 4 cannot be returned if D10 is many years in the past, then use this: =MIN(INT((TODAY()-D10)/365.25)+1,4) Hope this helps. Pete On Nov 8, 7:35 pm, Matt wrote: Sorry for not explaining the problem better. With the formula =INT((TODAY()-D10)/365.25); I get a value of "0" for the first year past todays date, and I can only have a max value of 4. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula take 3
<Hope this helps
And if it doesn't, please post again *In this thread*, don't start another one -- Kind regards, Niek Otten Microsoft MVP - Excel "Pete_UK" wrote in message ups.com... | So, what is your problem? Do you want 1 to be returned for the first | year? If so, add 1 to your formula. If you want to ensure that a | number larger than 4 cannot be returned if D10 is many years in the | past, then use this: | | =MIN(INT((TODAY()-D10)/365.25)+1,4) | | Hope this helps. | | Pete | | | On Nov 8, 7:35 pm, Matt wrote: | Sorry for not explaining the problem better. | | With the formula =INT((TODAY()-D10)/365.25); | I get a value of "0" for the first year past todays date, and I can only | have a max value of 4. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|