View Single Post
  #1   Report Post  
nsv
 
Posts: n/a
Default How to blank a cell with a formula


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