Clear Contents of Cells if value = 0.00

Good morning,

I'm working on a budget sheet. I have a form that uses logic to split between "expenses" and Credits.

If there is a credit, the form will ask for the purchase amount. The purchase amount will then be multiplied by .85. to determine the credit total.

My [Return Credits] column has a formula to calculate [Original Cost]@row * .85

straight forward and simple. This function works.

The problem is that the remainder of the column is filled with 0.00 if there was no refund. I would like to make it so a cell in [Return Credits] with a value of 0.00 be blank.

I've tried several suggestions I've found on the forums, but it seems they also blank out the cells with real values in it.

Thank you in advance for any help and suggestions.

Find more posts tagged with

Accepted answers

Coen

Thanks Kevin!

I needed to modify your suggestion just a little because I was unable to convert to row formula. What I ended up with was the following:

IF[Transaction Type]@row = "refund" , [original cost] @row * (.85)

Now I'm only seeing the calculations and the 0.00 cells are blank.

Thank You!

All comments

KevinPlut

Have you tried using an "if" formula to determine if the Return Credits column should calculate?

Something like "=IF([Is There a Credit?]@row = "Yes", [Original Cost]@row * [Return Rate]@row)"

Coen

Thanks Kevin!

I needed to modify your suggestion just a little because I was unable to convert to row formula. What I ended up with was the following:

IF[Transaction Type]@row = "refund" , [original cost] @row * (.85)

Now I'm only seeing the calculations and the 0.00 cells are blank.

Thank You!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.