Round amount to nearest $10 after other formula calc. in same cell

[Guest]

Cell A1 contains any number, say $2,882. Cell A2 contains a formula to
calculate 10% of cell A1 (result $288.2). How do I round up cell A2 to the
nearest $10 (result $290.00? I do not want to use another cell to calculate
the rounding, it has to be in cell A2.

 

[Guest]

Hi

Try this:
=MROUND(A1/10,10)

Andy.

 

[Scoops]

Hi debtors

If you only want to round up, try CEILING(A1/10,10)

Regards

Steve

 

[Robert_Steel]

Or to aviod the Analysis Tool Pack

=Round(A1*10%,-1)

hth RES

 

[Scoops]

=ROUND(A1*10%,-1) works for the cited 2882 but not for, say, 2842 which
yields 280, not 290 (if that's what the OP requires).

So, to continue with your example, =ROUNDUP...should be the way to go.

Regards

Steve