On Thu, 3 Jan 2008 12:36:00 -0800, lawson
wrote:

again, thank you very much, it works perfectly.

for the options that return numbers in a referenced range, i now get:

sf(d4) -- MAX(N62:N$66)+N$65
sf1(d4) -- MAX(N62:N$66)+3.14159265358979
sf2(d4) -- MAX(N62:N$66)+3.142
sf3(d4) -- MAX(0.999999, 4, 6.2831852, 3.14159265358979, 0.222222)+3.142
sf4(d4) -- MAX(1, 4, 6.283, 3.142, 0.222)+3.142

Excel should include these options in their functions...sf1 to 4 could be a
sf(d4,1) to ,4) type of function. i dare not ask you to create this option
for me, you've already done too much!

Glad it works for you!

Relatively simple to set up your option.

You already have your four formulas.

Just set up something like this:

Function ShowFV(rg As Range, Optional N As Long = 1)
Select Case N
Case Is = 1
ShowFV = ShowFV1(rg)
.....

Case Else
ShowFV = CVErr(xlErrNum)
End Select

End Function
--ron