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(A110, 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 ,
"Peter A" 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