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

 

[kpark91]

VBA Solution:

Function kpark91()
If Range("A1").Value < 46 Then
    kpark91 = Range("B1").Value + 356
ElseIf Range("A1").Value < 60 Then
    kpark91 = Range("B1").Value + 712
Else
    kpark91 = Range("B1").Value + 1000
End If
End Function

Edit: LOL. I was dealing with VBA so much that I totally forgot that you were asking for a formula...

 

[VoG]

Try


=IF(A1<46,B1+356,IF(A1>60,B1+1000,B1+712))

 

[Sektor]

Try.

=IF(A1<46;B1+356;IF(AND(A1>=46;A1<60);B1+712;B1+1000))

 

[Peter1973]

VoG I have used yours and amended it to :

=IF(F2<46,G2+1095,IF(F2>60,G2+365,G2+730))

However in F2 I have the following formula =NOW()-E2 which is preventing it form working any ideas?

 

[VoG]

Presumably you have a date in E2.

In what way isn't it working?

 

[Peter1973]

No its a number to calculate the persons age but it returns the same result no matter what the value in F2 is

 

[VoG]

NOW() is approximately 40675. You would have to subtract a pretty big number to get within the limits of the formula.

 

[Patcher]

Did you try Sektor's formula? That's the same one I came up with (except I used commas not semi colons). Depending on what result you're looking for, it worked for me.

 

[Peter1973]

Is there a way around this F2 contains the persons age so is calculated from their DOB?