v k abbey wrote:
how to round up integer values or real numbers to nearest tens e.g 214 to
210, 375 t0 380, 576 to 580 etc.

If you just want to change the last digit to zero, then =INT(A1/10)*10
might work, otherwise, I'd go with the previous responses.

Beege