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!

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

=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

I would suggest a MIN function.

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

AMcElfresh

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

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

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.