Rounding dollar amounts up/down when cents aren't part of the fact

G

Guest

Hello!

I am trying to set up a calculation to round dollar amounts up or down.
Cents are not included in the calculation and the cells have already been set
to not do decimal places. I have gone through the existing rounding posts and
found several helpful items that will work with other spreadsheets, but
nothing that seems to work with what I need at the moment.

Here are some examples:
$767,364 x 19.157 = $14,700,392 (need it to round to $14,700)
$160,824 x 11.687 = $1,879,550 (need it to round to $1,880)
$262,360 x 1.180 = $309,585 (need it to round to $310)

If this has been covered before I apologize for not finding it and would
greatly appreciate any help that can be given.

Thank you in advance!
 
G

Guest

Try this:

For values in A1 and B1
C1: =ROUND(A1*B1,-3)*0.001

Using your sample data of 767364 and 19.157,
C1 returns 14700

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

That is exactly what I was looking for! I had tried something similar, but
had not done the combination of -3 and 0.001 in the calculation. Thank you so
much, Ron, I really appreciate it!
 
G

Guest

You're very welcome. Thanks for letting me know that worked for you.

***********
Regards,
Ron

XL2002, WinXP
 

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

Rounding up for down based on cell value 3
Rounding a Formula Result Up or Down by the 100s 2
Calculate to the third decimal and round up or down in cell 6
Vlookup rounding up rather than down 4
Rounding Nearest Dollar 5
Access Rounding Dollar Amounts Up When Not Wanted 2
Rounding errors when a "5" is the third decimal place using formul 4
How do I round up to the nearest Dollar in Excel?? 5

Top