Roundup to higher 10s

[Muthukrishnan V]

Office 365

Roundup to higher 10s.

Sheet1, Cell E5 contains: 73

In sheet 2, Cell D5, I have a formula
="Dinner "&Sheet1!E5
and I get the output 73.
I want this formula improved to round up
to higher 10s, i.e. 80.

Kindly advise me the formula.

 

[etaf]

=CEILING(sheet1!E5, 10)

 

[Muthukrishnan V]

Sir, how do I combine the formulas:
="Dinner "&Sheet1!E5
and
=Ceiling(Sheet1!E5,10)
into one formula in Sheet2,Cell D5?

 

[Fluff]

Like

="Dinner "&Ceiling(Sheet1!E5,10)

 

[Muthukrishnan V]

Thank you Mr Fluff sir, Desired result I get.

 

[Fluff]

Glad we could help & thanks for the feedback.