IF Formula take 3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
<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

| 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
|
|
| > 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.
|
|
 
Back
Top