Creating a logic to convert a number's unit place into 9 (For MRP)

[Abhineet Gupta]

Hey,
In my job, I have to create pricing templates for our clients for different ecommerce market places. Lately I have been trying to automate the pricing as much as possible.
While calculating the MRP of any product, we keep it 3-4 times of the base cost. And we have to keep the MRP in the range where it ends with 9.
For eg : Base Cost*3=MRP i.e 115*3=345
Now I want to convert this into 349 as soon as MRP is calculated.
I have tried Mrange, Round but it works only for certain numbers in the list and not all.
If anyone could help me with this, it would be highly appreciated.

Thanks and Regards,
Abhineet

[JohnTopley]

Try

=CEILING(A5,10)-1

NOTE: 350 will be 349 but 351 will be 359

[AlphaFrog]

Another one

=INT(A1/10)*10+9