Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can you return a blank cell in a formula that isn't text?
Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value?
=IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2)
I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the blank cell is a textual value and not a number. The total column should result in a monetary value.
=IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2, 0)
When I have it return a 0, then the formula works but then I no longer have a blank, but rather a lot of zeros in that column.
Thank you very much!