rounding dollar amounts

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a formula that mulitplies a number by 0.012cents
to give me a dollar amount this works fine but it often
gives me a amount that goes to three decimal places
What i would like is to round up or down the third
decimal place to the nearest five or ten cent
eg: $12.284 would become $12.30
$36.153 would become $36.15
 
Dave,

Use =Round(amt,2)

So incorporating with the .012 multiplier, it would look like

=ROUND(A1*.012,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top