Clear cell from formula?

Is it possible to set a cell 'blank' from a formula? i.e. rather than
setting = 0 or setting to "" (empty string)
In other words IF (<data valid>, <do calculation>, <clear content>)

Thanks
Peter

--
Peter Aspey
E-mail: replace 6 by p

one way:

=IF(A1>10, A1*43.3, "")

This doesn't clear the content (the content will be a formula that
evaluates to a null string), but it will display as a blank.

In article <[email protected]>,
"Peter A" <[email protected]> wrote:

> Is it possible to set a cell 'blank' from a formula? i.e. rather than
> setting = 0 or setting to "" (empty string)
> In other words IF (<data valid>, <do calculation>, <clear content>)
>
> Thanks
> Peter