Thu 7 Dec 2006, 12:08Delegate Emma said...
Emma has attended:
Excel Intermediate course
PowerPoint Introduction course
Rounding numbers
Hi,
Can you tell me if it is possible to round numbers on excel to the next 50p? I realise that this is not the conventional way to round numbers. If, for example, a number is 34.02 I need it to round up to 34.50. Also, if a number appears as 56.73 I need it to round up to 57.00. Is this possible and, if so, how do I do it?
Many thanks!
Emma
Thu 7 Dec 2006, 15:51Trainer Richard said...
RE: Rounding numbers
Well Emma, that is a good one.
Try this:
=CEILING(A1,0.5)
Where A1 is the cell you want to round.
You could also nest another function where A1 is:
IE:
=CEILING(SUM(A1+A2),0.5)
OR
=CEILING(A1*0.12,0.5)
