View comments to see user responses…
Categories
-
Recent Posts
- Participate in the e-Journal Excel Users Forum
- How can I modify my formula to return a blank instead of 0?
- Why is the text of my formula displaying instead of the formula result?
- Why can’t I paste data into the template?
- Is there a way to auto-delete rows in my template that have no amount specified?
-
Recent Comments
- fx on Why is the text of my formula displaying instead of the formula result?
- Rebecca Baggett on Why can’t I paste data into the template?
- Rebecca Baggett on Why is the text of my formula displaying instead of the formula result?
- Rebecca Baggett on How can I modify my formula to return a blank instead of 0?
- Jacob Hintze on Is there a way to auto-delete rows in my template that have no amount specified?
Archives
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)