Hidden Data in Excel

[funkylad20]

Can someone remind me how to hide data in one cell (with a formula in it) if the data cell it is relying on is blank? I know it is an IF rule, with "", "" and stuff, but cannot remember the specifics...

ie - Cell A3 = A1-A2
A1 = Blank
A2 - Blank
Rather than displaying a '0', or '#DIV/0!' or '-', how will it display as blank?

Thanks!

[rinkins]

=IF(A2=0,"",A1-A2)

Or you could put A1 for the first part it's up to you! :-)