This function should give you what you want.

Just paste it into a module in vb on your workbook and then you should
be able to call it like any excel function

Just type in a cell =benifits(Number Of Cell with Salary )


Function benifits(Earnings)

If (Earnings 3500) Then

If (Round(((Earnings - 3500) * 0.4) + 1925, 0) 3500) Then
benifits = 3500
Else
benifits = Round(((Earnings - 3500) * 0.4) + 1925, 0)
End If

Else

benifits = Round(Earnings * 0.55, 0)

End If

End Function


Hope this helps

:)


--
Nigel_hough
------------------------------------------------------------------------
Nigel_hough's Profile: http://www.excelforum.com/member.php...o&userid=20623
View this thread: http://www.excelforum.com/showthread...hreadid=394278