Clear cell from formula?

  • Thread starter Thread starter Peter A
  • Start date Start date
P

Peter A

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
 
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.
 
Back
Top