Go on! Humour us, Paula! Tell us what you want the SUM function to do in
that formula?
You've calculated ((J3="tabloid")*(D3*F3*2)) ; what did you intend the SUM
function to add to that?
And then you've calculated ((J3="letter")*(D3*F3)) ; what did you intend the
SUM function to add to that result?
If you don't understand what the SUM function does, please look it up in
Excel help.
--
David Biddulph

"paulab" wrote in message
...
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???