If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. | | |
Thread Tools | |
Display Modes | |
|
|