Rounding Selling Prices Up to Two Price Points

Hi, Can anyone point me to a formula that can round up my selling prices to end in 5.00 or 10.00 dollars?

i.e. original price falls under the range from $zy0.01 to $zy5.00, formula will return a value of $zy5.00; original price falls within $z05.01 to $z10.00, formula will return a value of $z10.00

Thanks in advance for any advice and suggestions!


Johnny
Manks HK

Hi Ramananhrm

I have used the file you sent but not all results seem correct. Please see attached file.

My excel file will consist of a column of product costs (C), then a column of selling prices (S) with cell values calculated by multiplying (C) with a markup factor and formatted to be a number with two decimal places. The final column selling price (F) will be a rounded up figure ending with 5.00 or 10.00

I am looking for a formula to place in a the column (F), which if it works, can be dragged to the bottom of my file (which contains thousands of items) and save me from manually rounding up.

Thanks so much for your effort!

Rgds
Johnny

Sorry I probably did. But I tried putting in a new value and the result do not seem right. Do we have to perhaps use the roundup / round down functions?

Please check this file to see what I mean. By the way our selling prices can range from double-digit right up to 6-digits.

Thx.

Sorry ramananhrm, do you mean I have to do it for every new value?

Got ya. Trying it out now and many thx for your help ramananhrm!