smileypkr
Replies to this thread:
More by smileypkr
What people are reading
Subscribers
Please log in to subscribe to smileypkr's postings.
:: Subscribe
|
VBA code to calculate one number raised to the power another number i.e x to the power n
[VIEWED 7890
TIMES]
|
SAVE! for ease of future access.
|
|
|
smileypkr
Please log in to subscribe to smileypkr's postings.
Posted on 09-29-09 12:24
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
|
techGuy
Please log in to subscribe to techGuy's postings.
Posted on 09-29-09 1:09
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
http://www.excelfunctions.net/VBA-Operators-And-Functions.html Operator | Action | Precedence (1=top; 5=bottom) | ^ | The power operator | 1 | * | The multiplication operator | 2 | / | The division operator | 2 | \ | The integer division operator - this operator divides two numbers and returns the integer result (eg. 7\4 gives a result of 1) | 3 | Mod | The modulus operator - this operator divides two numbers and returns the remainder (eg. 8 Mod 3 gives a result of 2) | 4 | + | The addition operator | 5 | - | The subtraction operator | 5 |
|
|
|
xcopsgen
Please log in to subscribe to xcopsgen's postings.
Posted on 09-29-09 3:40
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Private Sub Power() Dim val1 as double; //val1 is x Dim val2 as double; //val2 is n Dim val3 as double; //val3 to store result val3 = val1 ^ val2; //val3 will have the result End Sub
|
|
|
shivanagar
Please log in to subscribe to shivanagar's postings.
Posted on 09-29-09 5:08
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
scopsgen, U might want to declare the power as function taking two parameters val1, val2 and returning val3, the code is not of any use if you can not give argument or get value. right?? smileypkr, Why do you need VBA for power, you have power function in Excel right, but if you want to use this in code makes sense, but you can always access inbuil power function using worksheetfunction property such as =Application.WorksheetFunction.Power(x,y)
|
|
Please Log in! to be able to reply! If you don't have a login, please register here.
YOU CAN ALSO
IN ORDER TO POST!
Within last 90 days
Recommended Popular Threads |
Controvertial Threads |
TPS Re-registration case still pending .. |
Anybody gotten the TPS EAD extension alert notice (i797) thing? online or via post? |
Toilet paper or water? |
ChatSansar.com Naya Nepal Chat |
Mamta kafle bhatt is still missing |
ढ्याउ गर्दा दसैँको खसी गनाउच |
Tourist Visa - Seeking Suggestions and Guidance |
Ajay Kumar Dev sentenced to 378 yrs |
Problems of Nepalese students in US |
Nepali Passport Renewal |
Biden out, Trump next president, so what’s gonna happen to TPS, termination? |
Are Nepalese cheapstakes? |
wanna be ruled by stupid or an Idiot ? |
Sajha Poll: Who is your favorite Nepali actress? |
अरुणिमाले दोस्रो पोई भेट्टाइछिन् |
seriously, when applying for tech jobs in TPS, what you guys say when they ask if you have green card? |
MAGA denaturalization proposal!! |
How to Retrieve a Copy of Domestic Violence Complaint??? |
Biden formally Stands Down!!! |
Nepali Psycho |
|
|
NOTE: The opinions
here represent the opinions of the individual posters, and not of Sajha.com.
It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address
if you want any posting to be considered for deletion. Your request will be
handled on a one to one basis. Sajha.com is a service please don't abuse it.
- Thanks.
|