if help

[Peter1973]

Hi I am trying to get an if to work but cant get it.

I need to look in A1 and if the value is less than 46 return B1+356 if A1 is greater than 46 but less than 60 return B1+712 and if A1 is greater than 60 return B1+1000.


Any help appreciated

 

[VoG]

Shouldn't it just be E2 instead of F2 in the formula?

If not please explain in detail what you are trying to do.

 

[Peter1973]

I am trying to get the formula to look in F2 which contains the persons age determined from =NOW()-E2 E2 contains their DOB.

Then if that agetis less than 46 return the date 3 years from I2 and if their age is between 46 and 60 return the date 2 years from I2 and if their age is 60 or over return the date 1 year from I2.

Thanks

 

[CharlesChuckieCharles]

INT(NOW()) = number of DAYS from 1901 or 1899 (40675) therefore age need to be times by 365 (or 365.25) but age 46 = 46*365 = 16790 now-age = 23885

What are you trying to DO?

 

[VoG]

Try in F2

=DATEDIF(E2,TODAY(),"y")

 

[CharlesChuckieCharles]

I am trying to get the formula to look in F2 which contains the persons age determined from =NOW()-E2 E2 contains their DOB.

Then if that agetis less than 46 return the date 3 years from I2 and if their age is between 46 and 60 return the date 2 years from I2 and if their age is 60 or over return the date 1 year from I2.

Thanks

IF(F2<46,Year(G2)+3,IF(F2>60,Year(G2)+1,Year(G2)+2))

F2 = Year(Now())-Year(E2)

 

[Peter1973]

1 problem with this the age only works out the year it doesnt take into acocunt months etc for example a person with a dob of 16/08/67 is 43 but the formula you suggest for f2 will show them as 44

 

[Peter1973]

Fixed it thanks for all your help