Clear Contents of Cells if value = 0.00

Options

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.

Best Answer

  • Coen
    Coen ✭✭✭✭
    Answer ✓
    Options

    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!

Answers

  • KevinPlut
    Options

    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
    Coen ✭✭✭✭
    Answer ✓
    Options

    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!