Formula to round up to the nearest 10 cents

[Mr2017]

Hi

Is there a formula to round up a number to the nearest 10 cents?

So if the number 0.78 was in cell A2, and it was increased by 10% in B2 to 85.8, it would be rounded up to 90 cents....


[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Number[/TD]
[TD="class: xl63, width: 64, align: right"]10%[/TD]
[/TR]
[TR]
[TD="align: right"]0.78[/TD]
[TD="align: right"]0.858[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Try:

	A	B
Number

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]10%[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"] $ 0.78 [/TD]
[TD="align: right"] $ 0.90 [/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=ROUND(A2*(1+B1),1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Mr2017]

Cool! Thanks Eric!

That worked!

 

[Eric W]

Glad to help!

 

[Rick Rothstein]

Cool! Thanks Eric!

That worked!

Just checking... are you sure Eric's formula always gives you the correct value? I ask because your original question was slightly confusing. You said...

"Is there a formula to round up a number to the nearest 10 cents?"

Your use of "round up" and "nearest" sort of conflict with each other. To know for sure if Eric's formula works for you all the time, what should the answer be if cell A2 contains 0.49 as a value? Increasing it by 10% would yield 0.539... rounding up would give 0.60 as the answer while just normal rounding to the nearest 10 cents (Eric's formula) would give 0.50 as the answer. If you really wanted rounding up, then just change Eric's ROUND function call to ROUNDUP...

=ROUNDUP(A2*(1+B1),1)

 

[Mr2017]

That’s a good spot, Rick!

Thank you!