How do i round up a price to the nearest 5,10,15 etc pence

's Computer Specifications

Looking for a formula in which i can use to round up prices to the nearest
5,10 pence etc as i have thousands of prices which need to be rounded up to
the nearest 5 pence, and need sum/formula which i can use. Please help and
advise if you can.

Kindest Regards

's Computer Specifications

Check the help for the ceiling function. It will probably do what you want.

"Millsy" wrote:

> Looking for a formula in which i can use to round up prices to the nearest
> 5,10 pence etc as i have thousands of prices which need to be rounded up to
> the nearest 5 pence, and need sum/formula which i can use. Please help and
> advise if you can.
>
> Kindest Regards

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there any way to round to the nearest 1/8, 1/4, etc in Excel.	=?Utf-8?B?TGlzYQ==?=	Microsoft Excel Worksheet Functions	5	13th Nov 2007 06:28 PM
How do I tell a price list to round up and down to the nearest 25	=?Utf-8?B?UGhpbGlwcGE=?=	Microsoft Excel Worksheet Functions	2	12th Jan 2006 01:57 PM
Rounding to nearest 50 pence	lal2707	Microsoft Excel Misc	1	6th Nov 2004 03:18 PM
Rounding to nearest 50 pence	lal2707	Microsoft Excel Misc	1	6th Nov 2004 12:11 PM
One Pence out query	Douglas	Microsoft Access Form Coding	0	11th May 2004 04:07 PM