Rounding up to the nearest 5 or 0

[RachelMads02]

Hi guys, I have a question about rounding functions. I've attached a photo to give a better understanding. I have a subtotal column which is the sum of the material cost, the processing cost, and the profit. For example the first line's subtotal is $40.82. I want to round that number up to the nearest $5.00 whole number amount, such as $45.00. My final sale price for each item has be rounded up to the nearest $5.00 or $10.00 amount, thus each sale price has to end in a 5 or a 0.

Each line:
40.82 = 45.00
50.82 = 55.00
50.82 = 55.00
48.82 = 50.00
50.82 = 55.00
55.82 = 60.00
60.82 = 65.00
45.82 = 50.00
52.82 = 55.00
40.82 = 45.00
55.82 = 60.00
50.82 = 55.00
50.82 = 55.00
48.82 = 50.00

I need to be able to drag this formula as new items are added as well. Does anyone have a solution for me? Thank you in advance to anyone who takes the time to help me!

rag rugs.jpg

[AlKey]

Try this one

=CEILING(A1,5)

Row\Col	A	B
1	40.82	45.00
2	50.82	55.00
3	60.82	65.00

[RachelMads02]

Bingo, that works!! Thank you very much!!!