Dear members, Thanks a lot for the valuable suggestions. The list has really helped us immensely to crack our troubles instantly.
On 4/23/10, Amiyo Biswas <amiyo.bis...@gmail.com> wrote: > Hello, > > In Excel, use ^ (caret) for power sign, e.g. 6^3 =216. Alternately, you can > use the power function for it. Say for instance, when cell A1 contains 6 and > B1 3, the following formula in cell C1 will yield 216: > =Power(a1^b1) > > For compound interest, the formula should be: > =A2*(1+B2/100)^C2 > When A2 is Principal, B2 Rate of interest and C2 Number of years > > For inserting a caret sign, use shift+6 on the alphanumeric keypad. > > With Best regards, > Amiyo Biswas. > Cell: 91-9433464329 > > ----- Original Message ----- > From: "Himanshu Sahu" <sahu.himanshu2...@gmail.com> > To: <accessindia@accessindia.org.in> > Sent: Friday, April 23, 2010 11:20 AM > Subject: Re: [AI] EXCEL FORMULA > > > 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 > > > > > 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