Rounding up or down

[Taylor]

I am working on an excel spread sheet running price costing numbers. I want
the numbers to round up to multiplies ending in 5 or 0. Example if I have a
cost of $ 122.18, I need to round to 120.00 if the the number is 124.88 I
need the number to round up 125.00.

 

[JE McGimpsey]

One way:

=ROUND(A1*2,-1)/2

 

[BoniM]

=MROUND(A2,5)

Where A2 contains the value you want to round...

 

[Taylor]

Thanks but your answer cut my value in half.

One way:

=ROUND(A1*2,-1)/2

 

[JE McGimpsey]

Then you didn't enter it correctly.

Thanks but your answer cut my value in half.