# Generating an "if greater than zero, then this" "if less than zero, then that" formula

Below is the formula that I'm trying to use.

=IF([Days Behind]@row <=0,“\$0.00”, [Days Behind]@row >0, [Days Behind]@row * 257

Essentially I want the cell to read as "0.00" if the days behind column is 0 or below. If the days behind column is 1 or above I would like it to read as the formula [Days Behind]@row * 257

• =IF([Days Behind]@row > 0, [Days Behind]@row * 257, 0)

Format the column as currency and there is no need to worry about dollar signs and decimals in the formula.

• I would suggest a MIN function.

=MIN([Days Behind]@row, 0) * 257

thinkspi.com

• Thanks Carson! That works!

The minimum function doesn't seem to return the correct result for some reason Paul.

Thanks for everyone's help!

• Sorry about that. I was going too fast. It should be a MAX function. Time for another cup of coffee.

=MAX([Days Behind]@row, 0) * 257

thinkspi.com

• I love this approach... making a note of it.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!