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.
Best Answer

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

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)"

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!