adding less than variable



I have the following formula: =SUM((Length@row * Width@row) / 144 * 150)

I would like to add a variable that gives a result of $491 for an result that is less than $491 but answers the above equation for any sum that is greater than $491

ie: example 1. 24*12/144*150 = $300-- I'd like the answer to populate as $491 instead of $300

example 2. 30*20/144*150=$625-- it should populate as $625

thank you for your help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!