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

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!
--
PhenyxFire
Always five, acting as one.

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

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


"PhenyxFire" wrote:

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!
--
PhenyxFire
Always five, acting as one.

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

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!
--
PhenyxFire
Always five, acting as one.


"Ron Coderre" wrote:

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


"PhenyxFire" wrote:

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!
--
PhenyxFire
Always five, acting as one.

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

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

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

XL2002, WinXP


"PhenyxFire" wrote:

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!
--
PhenyxFire
Always five, acting as one.


"Ron Coderre" wrote:

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


"PhenyxFire" wrote:

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!
--
PhenyxFire
Always five, acting as one.