i tried getting help at a different forum but was treated like crap, and no body would help me. So, ive come here because everyone seems nice and knowledgeable.

Im trying to make it so: if 15 is entered in cell A1 then show 2 in cell A3, if 16 is entered into cell A1 then show 3 in cell A3, if 17 is entered into cell A1 then show 4 in cell A3 etc... and if the number is less than 15 show 0.

i've tried just about everything and nothing works, i usually get the #NAME? error. can someone please help me out here, i would be eternally grateful. thank you.

Hi

This function is all you need

Function Sample(Number)
Select Case Number
    Case Is >= 15
        Sample = Number - 12
    Case Else
        Sample = 0
End Select
End Function

If you get #NAME you have mistyped function name


-vemaju

Excuse me if you've already got this one cleared up but you can solve the problem with Excel worksheet formulae alone - no need for VBA. Just type the following in cell A3:

=MAX(A1-15,0)

HTH,
Maccas