Try

=IF(C1<1,NA(),WEIBULL(A1,C1,C2,FALSE))

if you don't like the look of #N/A in the cell you can use format
conditional formatting formula is and use =ISNA(C1)
then use a white font


--

Regards,

Peo Sjoblom



"nsv" wrote in message
...

This has probably been asked before so forgive me; I cannot find
anything about it

I want to draw the Weibull frequency distribution.
If the form factor is less than 1, the formula calculates 0 for x =0,
but the real function approaches infinite. Therefore I want to exclude
this single point, but it is not possible. I can write something like
=IF(C1<1,"",WEIBULL(A1,C1,C2,FALSE)), but the "" is interpreted like a
0, and this exactly what I want to avoid.

Is there a function that works like
IF(C1<1,BLANKCELL,WEIBULL(A1,C1,C2,FALSE))?

NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=482190