View Single Post
  #1   Report Post  
Pricing Queen
 
Posts: n/a
Default 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?