Hi,

I used  =MROUND(H14*I14%,1) formula. It gave different results for 275.50 and 449.50. I could not understand. The former rounded to add while later rounded to deduction.

please help.

• Edited by drsantoshsinghrathore Thursday, May 07, 2015 2:58 AM
• Moved by Lanlan HuangMicrosoft contingent staff 5 hours 29 minutes ago

What happens if you display more decimal places? I suspect that 449.50 is actually something like 449.4999999999, so that it is rounded down.

Hi Hans Vogelaar,

Thank you for your reply,

I find it not so,

These are how these formula are there in excel sheet.

I see - that's weird... If you use =ROUND(H14*I14%,0) you do get the correct result.

Hi,

Thank you Hans Vogelaar,

I learnt some where on net that "=MROUND(H14*I14%,1)"  to be correct formula !!

Hope  =ROUND(H14*I14%,0) will always work well.

regards

Hi drsantoshsinghrathore,

I am glad your issue has been resolved, and this forum is discussing about Excel developing like Excel automation, Excel Customization. Your issue is about Excel formula which is a product issue, I will move this thread to the correct forum.

In addition, if you have any issues about Excel product, I will recommend you post your issue in the forum below:

Excel IT Pro Discussions: http://social.technet.microsoft.com/Forums/en-US/home?forum=excel

Best Regards,

Edward