[AI] EXCEL FORMULA
Surya Prakash Sharma
surya.sharma26 at gmail.com
Thu Apr 22 11:31:48 EDT 2010
could you please send a tutorial on excel formulas on my mail ID. i have
gone through the notes on excel provided by nab delhi. thanks in advance.
----- Original Message -----
From: "Kamal Verma" <kamalverma at pnb.co.in>
To: <accessindia at accessindia.org.in>
Sent: Thursday, April 22, 2010 11:28 AM
Subject: [AI] EXCEL FORMULA
> 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.
> To unsubscribe send a message to accessindia-request at accessindia.org.in
> with the subject unsubscribe.
> To change your subscription to digest mode or make any other changes,
> please visit the list home page at
More information about the AccessIndia