Round off

Hello everyone, i should rly need some help with my excel-work.

Atm, my problem is that i´ve made a funtion with "Round off" that makes the significans be "5" all the time. But the problem is that when the mesure reaches over 80 i need it to "round off" at even 10mm, like 90, 100, 110 etc instead of 85,90,95...

If anyone got a sollution to this problem, please help me

Thanks in advance

And i´m not sure i understand your function "Celeing" eventhough i do know what i means. Trying to find the swedish version for the word, so that i can find it in Excel.

ceiling rounds a number up eg ceiling(57,5)=60 the ceiling is the top of a room
floor rounds a number down eg floor(57,5)=55 the floor is the bottom of a room!
round rounds to the nearest digit of significance round(57*2,-1)/2 =55

so it depends what round off means, if it is up, down or to the nearest, you take your choice
=IF(A1>80,CEILING(A1,10),CEILING(A1,5))

or
=IF(A1>80,floor(A1,10),floor(A1,5))

or
=IF(A1>80,round(A1,-1),round(A1*2,-1)/2)

Regards

Dav