function getting #Name? error

[Bullsandbears123]

I'm using this function in Excel and I am getting a #name? error. Any ideas?

Function TAXCAL(LT As Double, ST As Double, Lrate As Double, Srate As Double) as double

Dim LTax As Double
Dim Stax As Double



If LT >= 0 And ST >= 0 Then
LTax = LT * Lrate
Stax = ST * Srate
TAXCAL = LTax + Stax

ElseIf LT + ST = 0 Then
TAXCAL = 0

ElseIf LT - ST > 0 Then
LTax = LT * Lrate
TAXCAL = LTax

ElseIf ST - LT > 0 Then
Stax = ST * Srate
TAXCAL = Stax
Else
TAXCAL = 0

End If


End Function

 

[VBAjedi]

Have you tested to make sure you are passing it valid parameters? Try adding a messagebox at the top of your code that prints out the parameter values the function has received, then make sure those are what you expect.

VBAjedi

 

[Bullsandbears123]

Solved it, thanks, I didn't put it in a Module, I put it in the Worksheet code.

 

[TonyJollans]

Hi Bullsandbears123,

Where have you got your code? It needs to be in a code module, not a sheet.

Enjoy,
Tony

-----------------------------------------------
A very Merry Christmas to all Tek-Tippers
----------------------------------------------- [santa2]

 

[TonyJollans]

Oh, you found it out yourself - must type faster

Enjoy,
Tony

-----------------------------------------------
A very Merry Christmas to all Tek-Tippers
----------------------------------------------- [santa2]

 

[VBAjedi]

Tony,

I would expect something more along the lines of "A very Jolly Christmas to all Tek-Tippers" from you, Mr. Jollans!


VBAjedi

 

[TonyJollans]

Hi jedi,

Would you believe it never crossed my mind when I set it up? It isn't just in programming where the blindingly obvious and over-familiar just isn't visible even when it's staring you in the face, but just for you ...

Enjoy,
Tony

-----------------------------------------------
A very Jolly Christmas to all Tek-Tippers
----------------------------------------------- [santa2]

 

[Bullsandbears123]

HAPPY HOLIDAYS!!!!