Elseif function error

[concatch]

Hi,

I've created a simple function but it doesn't seem to work. Any help would be greatly appreciated.

Thanks a million!

[JosephP]

Function getelasticity(rng As Range) As String
    Dim strReturn As String

    If rng.Value = 0 Then 
       strReturn = "Perfectly Inelastic Demand"
    ElseIf rng.Value > -1 And rng.Value < 0 Then
        strReturn = "Inelastic Demand"
    ElseIf rng.Value = -1 Then 
       strReturn = "Unit Elastic Demand"
    ElseIf rng.Value > -9999 And rng.Value < -1 Then 
       strReturn = "Elastic Demand"
    ElseIf rng.Value < -9999 Then 
       strReturn = "Perfectly Elastic"
    Else
 strReturn = "UNKNOWN"
    End If
    getelasticity = strReturn
End Function

[concatch]

Thanks a million!!!

[AB33]

I do not see any error on the function

[AB33]

Jay,
No code tags

[JosephP]

sure there are ;-)

[StephenR]

You need to check out If-Then-Else syntax: http://www.techonthenet.com/excel/formulas/if_then.php

and don't forget to assign the value of the string variable to your function at the end!

Edit: sorry, a bit slow.