adding less than variable

L Duff

Hello,

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

MCorbin

Try this:

=IF(SUM((Length@row * Width@row) / 144 * 150) < 491, 491, SUM((Length@row * Width@row) / 144 * 150))

MCorbin

Try this:

=IF(SUM((Length@row * Width@row) / 144 * 150) < 491, 491, SUM((Length@row * Width@row) / 144 * 150))

L Duff

Thank you so much- that works!