Excel rounding to ten

J

jmbelleek

In excel is there a way in formula to set one cell to give the total rounded
to the nearest tens? Total is $338 but I want $340
 
J

JasperBlaas

I can only come up with dividing it by 10 first, then rounding it an
then multiplying it again:

=ROUND(338/10;0)*10

Would do the trick
 
Top