Excel VBA Round-off issue

[xlhelp15]

Hello Experts - I'm facing issue in round-off for the below condition,

Billed Amount : 84.65
Percentage : 150%

84.65 * 150% = 126.975 - I need 126.98 in final output.

Have tried it, Round(cells(counter,1).value, 2) ; 126.98 but when I press F2 in the respective cell it still shows 126.975.

pls. help me to fix it.

 

[Joe4]

Re: Excel VBA Round-off issue - Help needed

Are the calculations being done on the worksheet or in VBA code?
What is actually in your cell, the formula, or a hard-coded value?
Can you post your full VBA code?

 

[xlhelp15]

Re: Excel VBA Round-off issue - Help needed

Thank you for your kind response.

If Cells(myCount, 18).Value <> "" Then
Cells(myCount, 21).Value = (Cells(myCount, 19).Value * Cells(myCount, 9).Value)
Cells(myCount, 21).Value = Round(Cells(myCount, 21).Value, 2)
Cells(myCount, 10).Value = Cells(myCount, 8).Value - Round((Cells(myCount, 21).Value), 3)
Cells(myCount, 10).Value = Round(Cells(myCount, 10).Value, 3)
Cells(myCount, 10).Value = Cells(myCount, 10).Value * 100
end if

 

[Joe4]

Re: Excel VBA Round-off issue - Help needed

How/when are you running this code?

 

[xlhelp15]

Re: Excel VBA Round-off issue - Help needed

I found the way which I learnt from here. Thanks much for your assistance.

 

[Joe4]

Re: Excel VBA Round-off issue - Help needed

So what ended up being the issue?