Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If/Then formula help
I have the following formula in a field to calculate a cost:
=IF([PreID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6)
However, if the result of this calculation is not at least $300.00 I need the formula to insert $300 instead of what is actually calculated. How would I modify this formula? Is this possible?
Thank you, Jennifer
Comments

You can put that whole thing in another IF:
TL;DR  you want this:
=IF(IF([PreID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6) < 300, 300, IF([PreID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6))
If I relable your formula (without the as YourWholeIF, what I did was
=IF(YourWholeIF < 300, 300, YourWholeIF)
which says, "if YourWholeIF is less than 300, then the result is 300, otherwise it is YourWholeIF".
Hope that helps!

I think Craig meant =MAX instead of =MIN, but I do like his format better.

Jennifer,
Or this
=MAX(IF([PreID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6),300)
(FIXED! Doh!)
Craig

Oh brillian J. Craig!!! It worked. Thank you.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives