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
|