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

Thank you in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!