How do I round up or down using formulas?

G

Guest

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

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up or down to $X.X9 or up to $X.X5 10
In Excel, how do I look for the last number either 0 or 5 1
How do I correct rounding errors in Excel formulas? 1
How do I create the formula for this calculation? 1
How do I tell a price list to round up and down to the nearest 25 2
How do I round Up to the nearest hundred? 8
How do I round down currency in Excell? 2
Should I get a vasectomy or would putting a cell fone in my jockstrap be just as good? 2

Top