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

=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
Categories
Check out the Formula Handbook template!