How can I modify my formula to return a blank instead of 0?

View comments to see user responses…

Subscribe to the FBS News E-mail ListSubscribe to the FBS News E-mail List

One Response to How can I modify my formula to return a blank instead of 0?

  1. Rebecca Baggett says:

    When a blank cell is referenced, Excel returns a “0″ in the formula result by default. This causes the row to fail e-Journal validation. To get around this Excel behavior, you can modify your formulas to return blanks. Here is one example that works on text fields:

    instead of:
    =Sheet1!A3
    try:
    =IF(Sheet1!A3=0,””,Sheet1!A3)