change the last digit into zero form

[rajkumarchaudhary]

Im using this function but not solved:

=LEFT(A1,LEN(A1)-1)&N(RIGHT(A1,0))

[Glenn Kennedy]

Exactly what do you expect/want the formula to do?

[Glenn Kennedy]

Are you trying to round to the nearest multiple of 10???

=10*ROUND(A1/10,0)

[rajkumarchaudhary]

I want to change the last digit of the numbers like: in the value of the cell 2389 or 2388 or 2387 will change equal to 2380. or any above value of 10. like if 11 will change equal to 10, or 21 equal to 20,

[rajkumarchaudhary]

It works thank you Glenn

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.