P
plh
I have changed a 2001 worksheet having numerous user defined functions such as:
Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))
End Function
These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh
Function VEPT_Pre(Sigma, ProcessTime, MTTF, MTTR)
'Variance of effective Process Time page 262 Formula 8.6
'pre-emtive failures
VEPT_Pre = (Sigma / Availability(MTTF, MTTR)) ^ 2 + _
((2 * ProcessTime * MTTR * (1 - Availability(MTTF, MTTR))) / Availability(MTTF,
MTTR))
End Function
These were working fine in 2001 but now in 2008 as Process.xlsm They are
generating #NAME errors. I was using them on one of the worksheets. If I try to
put one in a new cell the "insert function" fx at the end of the formula bar can
see it, but claims that it takes no arguments. But you can easily see the
arguments up there.
What do I have to do to get them to work again?
Thank You,
-plh