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
