[AI] EXCEL FORMULA

Himanshu Sahu sahu.himanshu2010 at gmail.com
Fri Apr 23 04:40:15 EDT 2010


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.biswas at 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.himanshu2010 at gmail.com>
> To: <accessindia at 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 <bsvermadurg at 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.sharma26 at gmail.com>
>> To: <accessindia at 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" <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,
>>>>
>>>>
>>>>
>>>> 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-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
>>>>
>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>>
>>>
>>>
>>>
>>> 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
>>>
>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>>
>>
>>
>>
>>
>> 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
>>
>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>
>
> --
> Thanks and regards
>                    Himanshu Sahu
> Reach: 09051055000
>
>
>
> 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
>   http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>
>
>
> 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
>   http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>


-- 
Thanks and regards
                   Himanshu Sahu
Reach: 09051055000




More information about the AccessIndia mailing list