Try something like this: Example: If formula is in lets say C1.
If(A1="","",A1+B2)

"JSN" wrote:

Trying to make a spreadsheet more presentable by removing the #DIV0!
statements which result in formulas with 0 or no values.