How to blank a cell with a formula

[nsv]

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

 

[Peo Sjoblom]

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

 

[Search33]

Or,
you can use " " instead of "" to make the cell just a space.

- Search

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