I have never liked the IIF construct!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tushar Mehta" wrote in message
om...
Or what I would use:

MyFunc = x + IIf(z, y, -y)
MyFunc = x + y * IIf(z, 1, -1)

To the point, no code duplication, and easier to maintain.

It would be even more useful if VB terminated its evaluation as soon as
the result was determined.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Use Alt+F11 to open VB Editor
Use command Insert | Module
Copy this to the newly open module sheet
Function Myfunction(x, y, z)
If z Then
multi = 1
Else
multi = -1
End If
Myfunction = x + y * multi
End Function
Return to Excel and type in any cell =Myfunction(A1,B1, T10)

But why not use
Function Myfunction(x, y, z)
If z Then
Myfunction = x + y
Else
Myfunction = x - y
End If
End Function

best wishes