Rounding up or down to the nearest 50 cents
Author Message
Rounding up or down to the nearest 50 cents

I have a price list I need to round up or down to the nearest 50 cents?

I have tried using =IF without much success.

For example:( the price range varies from \$1.20 up to \$50.00)

4.13
4.27 would round down to 4.00

4.33
4.42 would round up to 4.50

4.68
4.71 would round down to 4.50

4.82
4.92 would round up to 5.00

Regards

Peter

Sun, 15 May 2005 07:27:00 GMT
Rounding up or down to the nearest 50 cents
Don't know how long it's been around (sorry!), but in XL2K2 there's eg:

=MROUND(A1,0.5)

Rgds,
Andy

Sun, 15 May 2005 07:35:23 GMT
Rounding up or down to the nearest 50 cents
One way:

=ROUND(A1*2,0)/2

Quote:

> I have a price list I need to round up or down to the nearest 50 cents?

> I have tried using =IF without much success.

> For example:( the price range varies from \$1.20 up to \$50.00)

> 4.13
> 4.27 would round down to 4.00

> 4.33
> 4.42 would round up to 4.50

> 4.68
> 4.71 would round down to 4.50

> 4.82
> 4.92 would round up to 5.00

> Many thanks for your help.

> Regards

> Peter

Sun, 15 May 2005 07:35:34 GMT
Rounding up or down to the nearest 50 cents
It's in other versions, too - it's part of the Analysis Toolpak Addin.

Quote:

> Don't know how long it's been around (sorry!), but in XL2K2 there's eg:

> =MROUND(A1,0.5)

Sun, 15 May 2005 09:20:43 GMT

 Page 1 of 1 [ 4 post ]

Relevant Pages