Rounding Function
Posted by Steve Shoebottom on November 23, 2001 10:28 AM
I have a problem where I want to round up my selling prices to end in either £5.00 or £9.00. For instance working from a cost of £55.00, adding a mark-up of 10%, will give me a selling price of £60.50, however any selling price that results between ##9.01 and ##4.99 must be rounded up to ##5.00 (as the above does, i.e. £60.50 must be £65.00!). By the same token any selling price calculated from any particular margin that falls between ##5.01 and ##8.99 needs to be rounded up to ##9.00. This formula obviously needs to be copied to suit an infinite number of selling prices i.e £6.99, £128.45, etc.. Remember the goal is to show a selling price "ending" in either £5.00 or £9.00