Rounding up

[pauldaddyadams]

Hi all

I need some help with a formula that rounds up percentages

e.g. if cell A1 contains the following then i need it rounding up to the nearest point 5:
Contains Result needed
0.71 0.75
0.72 0.75
0.73 0.75
0.74 0.75
0.75 0.75
0.76 0.80
0.77 0.80

etc

Anyone able to help?

Paul

[npamcpp]

=ceiling(a1,0.05)

[pauldaddyadams]

Thanks for the reply - had to change it to 0.005 but it then worked

[npamcpp]

had to change it to 0.005 but it then worked

That's strange. Changing the second parameter to 0.005 would yield

0.71
0.72
0.73
0.74
0.75
0.76
0.77

see file attachment.

[pauldaddyadams]

I have uploaded the file - i dont know why i had to use 3 decimal places

[npamcpp]

i dont know why i had to use 3 decimal places

because the value in the cell is not 0.76, but 0.76%, i.e. the underlying number is

0.0076

Keep in mind that the percentage format is just that: a format. It does not change the underlying number, just the way it is being displayed.