=MAX(SUM((J3="tabloid")*(D3*F3*2))+SUM((J3="letter ")*(D3*F3)),1000)

"paulab" wrote:

Hello,
With help from the message board......
My formula: =SUM((J3="tabloid")*(D3*F3*2))+SUM((J3="letter")*( D3*F3))
Now I would like the result to round up to 1000 ONLY if less than 1000.
Would like the result to stay what it is if over 1000.
How would I accomplish this???