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???

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