[AI] EXCEL FORMULA

Kamal Verma kamalverma at pnb.co.in
Fri Apr 23 01:53:19 EDT 2010


Hello,

It is "^".

Kamal Verma
----- 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



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. 




More information about the AccessIndia mailing list