Round dollar amounts

[Windowgirl]

I need help. My company is working on it's price books and I need to
find out how I can get an answer to come out of the nearest NICKEL...

Each cell that is a price, is an equation of a base price times a
multiplier. I need to make that answer round to the nearest five
cents.

Lets say I have a 4.41 dollar item and it multiplied by the value in
C1 which is 3. How do I get 13.23 (the answer) to show up as 13.25??

Any suggesions?

Thanks
WIndow girl

 

[Jason Morin]

One way:

=ROUND(4.41*C1/0.05,0)*0.05

HTH
Jason
Atlanta, GA

 

[Ken Wright]

=ROUND(A1*2,1)/2

or with the Analysis Toolpak installed

=MROUND(A1,0.05)

If you only want to round down or up, then check out the FLOOR and CEILING
functions, or use ROUNDUP/ROUNDDOWN in the first formula

 

[JE McGimpsey]

one way:

Say the $4.41 is in B1. Then

=ROUND(B1*C1*20,0)/20

 

[Frank Kabel]

Hi
try
=ROUND((4.41*C1)*20,0)/20

HTH
Frank

 

[Mehul Hathi]

Excellent formulae. However, how does the calculation
of "20" work over here. Couldn't get a glimpse of it

-----Original Message-----
one way:

Say the $4.41 is in B1. Then

=ROUND(B1*C1*20,0)/20

 

[JE McGimpsey]

The general form is, to round to the nearest N:

=ROUND(A1 * 1/N, 0) * N

since the OP wanted to round to the nearest N=0.05, 1/N = 20 so the
formula became

=ROUND(A1 * 20, 0) * 0.05

or, equivalently

=ROUND(A1 * 20, 0)/20

 

[mehul.hathi]

Thanks a bunch!!! it worked..

-----Original Message-----
The general form is, to round to the nearest N:

=ROUND(A1 * 1/N, 0) * N

since the OP wanted to round to the nearest N=0.05, 1/N = 20 so the
formula became

=ROUND(A1 * 20, 0) * 0.05

or, equivalently

=ROUND(A1 * 20, 0)/20


.