Remember Me?

#1
November 29th 04, 05:21 PM
 Pricing Queen Posts: n/a
How do I round up or down using formulas?

I manage pricing on spreadsheets where the pricing is typically done per 1000
(M) and the customer is invoiced by the case. A case can be quantities other
than 1000, ie: 2400/cs. On a spreadsheet, if you have a price per M of \$7.48
and a formula that calculates a case price, the calculation figures \$17.96.
It is rounding up from \$17.952. In this case I want the number to round down
to \$17.95. How do I do this?

#2
November 29th 04, 05:26 PM
 JulieD Posts: n/a

Hi

17.952 shouldn't round automatically to 17.96 ...
anyway here's some rounding options for you (with 17.952 in A1)

=ROUND(A1,2)
returns 17.95
=ROUNDUP(A1,2)
returns 17.96
=ROUNDDOWN(A1,2)
returns 17.95

Hope this helps
cheers
JulieD

"Pricing Queen" <Pricing wrote in message
...
I manage pricing on spreadsheets where the pricing is typically done per
1000
(M) and the customer is invoiced by the case. A case can be quantities
other
than 1000, ie: 2400/cs. On a spreadsheet, if you have a price per M of
\$7.48
and a formula that calculates a case price, the calculation figures
\$17.96.
It is rounding up from \$17.952. In this case I want the number to round
down
to \$17.95. How do I do this?

#3
November 29th 04, 06:15 PM
 Bob Phillips Posts: n/a

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Larry F Excel Worksheet Functions 4 February 2nd 05 06:46 AM John Lovin Excel Discussion (Misc queries) 3 January 18th 05 10:50 PM John Excel Discussion (Misc queries) 0 January 12th 05 04:29 PM jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM

All times are GMT +1. The time now is 01:39 AM.