Rounding to nearest 50 pence

L

lal2707

I am trying to get a number resulting from a formula to be rounded up o
down to the nearest 50 pence i.e.

1.1 -> 1.5 rounded to 1.5
1.6 -> 1.9 rounded to 2.0 etc

How do I do this?

The ROUND, ROUNDUP and ROUNDDOWN,FLOOR, CEILING do not give desire
results?

Thank
 
K

Ken Wright

I'm confused - you say you want to round to the nearest 50p, but then you give
examples of what you want such as 1.4 going UP to 1.5 and 1.6 going UP to 2.
The nearest one to 1.6 is also 1.5. From your examples I would have thought
CEILING(Number,0.5) would give you what you want as it returns the answers in
your examples.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ROUNDING UP TO NEAREST 9 5
Rounding to the nearest cent...currency values 3
Rounding to nearest 0.5 in Excel 2007 4
Rounding to the nearest 50 cents 4
Round Number to Nearest 50 3
MOD and Ceiling formula used to round up and down to 49 and 99 3
rounding down to nearest 1/32 3
Round up to nearest 25 or 50? 6

Top