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 PricingPosted 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.
Excel Returns $7.24 I want the result $7.49.
Excel Returns $7.54 I want the result $7.99.
|Check out our Excel Resources
Re: Roundup to nearest $.49 or $.99 in Retail PricingPosted 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.