Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Take a look at http://www.xldynamic.com/source/xld.Rounding.html
-- HTH RP (remove nothere from the email address if mailing direct) "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extend data range format and formulas | Excel Worksheet Functions | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |