Dear list members, I also have a query regarding Excel formula. How can we put "Power” sign in excel sheet? Simply I wish to extract compound interest. Does the formula vary in Excel sheet from the conventional one?
On 4/23/10, BHAWANI SHANKAR VERMA <bsvermad...@gmail.com> wrote: > i know prof. anil khurana, at shyamlal college. he was an active participant > in accessindia. in my opinion he is a master in excel. > > ----- Original Message ----- > From: "Surya Prakash Sharma" <surya.sharm...@gmail.com> > To: <accessindia@accessindia.org.in> > Sent: Thursday, April 22, 2010 9:01 PM > Subject: Re: [AI] EXCEL FORMULA > > >> Hi, >> 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. >> sps >> ----- Original Message ----- >> From: "Kamal Verma" <kamalve...@pnb.co.in> >> To: <accessindia@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, >>> >>> >>> >>> DISCLAIMER: >>> >>> >>> 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-requ...@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 >>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> >> >> To unsubscribe send a message to accessindia-requ...@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 >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> > > > > > To unsubscribe send a message to accessindia-requ...@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 > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > -- Thanks and regards Himanshu Sahu Reach: 09051055000 To unsubscribe send a message to accessindia-requ...@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 http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
