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

AMcElfresh · 05/26/23

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!

Carson Penticuff · 05/26/23

=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.

Paul Newcome · 05/26/23

I would suggest a MIN function.

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

AMcElfresh · 05/26/23

Thanks Carson! That works!

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

Thanks for everyone's help!

Paul Newcome · 05/26/23

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

Carson Penticuff · 05/26/23

https://community.smartsheet.com/discussion/comment/377788#Comment_377788

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

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

Answers

Help Article Resources

Categories