Kamal Verma kamalverma at pnb.co.in
Thu Apr 22 01:58:38 EDT 2010

Hello everyone,

I want to round off the figure in nearest rupee. Suppose, I enter 9.03 in 
A1, it should appear as 10.00 in the same cell. Further, I enter 99.10 in 
B1, it should automatically be changed to 100.

Please suggest me any formula or macro in this regard. Though I am well 
acquainted  with excel formulae, this exercise is out of my comprehension.

Kamal Verma,


The Information transmitted in this email is solely for the addressee. It is confidential and may be legally privileged. Access to this email by anyone else is unauthorized. Any disclosure, copying, distribution or any action taken by anyone other than by the intended recipient is prohibited and may be unlawful. If you are not the intended recipient then kindly delete the mail from your system. Any opinion or views expressed in this mail may not necessarily reflect that of Punjab National Bank. The bank considers unencrypted email as an insecure mode of communication. 

More information about the AccessIndia mailing list