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

Many thanks for your help.

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  
 
 [ 4 post ] 

 Relevant Pages 

1. Rounding down to the nearest 50

2. Round value to the nearest 25 / 50 / 75 and 100

3. ROUND to nearest 50 problem

4. Rounding Currency to the nearest 5 cents - HELP!

5. Rounding a number to the nearest 5 cent

6. Rounding To nearest 05 Cents in Excel 97

7. Round up to nearest 5 cents?

8. Rounding to nearest 5 cents

9. Round up to nearest 5 cents?

10. Rounding to the nearest 5 cent interval


 
Powered by phpBB® Forum Software © phpBB Group