Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Roundup to nearest $.49 or $.99 in Retail Pricing

Posted by Al Flori on October 24, 2001 5:37 AM
I am trying to calculate retail prices using excel. What I would like to to be able to do is round all numbers to the nearest $.49.
For example:
Excel Returns $7.24 I want the result $7.49.
Excel Returns $7.54 I want the result $7.99.
Thanks

Check out our Excel Resources

Re: Roundup to nearest $.49 or $.99 in Retail Pricing

Posted by Mark W. on October 24, 2001 5:56 AM
Use =CEILING(A1,0.5)-0.01 where cell A1 contains
your retail price.

Hope you have lots of pennies in your register!


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.