[Show all top banners]

smileypkr
Replies to this thread:

More by smileypkr
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Discussion Refresh page to view new replies
 VBA code to calculate one number raised to the power another number i.e x to the power n
[VIEWED 4532 TIMES]
SAVE! for ease of future access.
Posted on 09-29-09 12:24 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 

any help is appreciated


 
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


 
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


 
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
TRUMP 2016!!! Here is why?
Wedding Costs in Nepal ? Party, Band Baaja !!!!???
अनभिज्ञ तिमी
TPS FEDERAL NOTICE
6 ÷ 2(2 + 1)=
Check out HOW TO : workout Videos
coding at age of 45
LAX to Guangzhou to Nepal - CS Air
वा अमेरिका !! थू अमेरिका !! दलदल अमेरिका
लिङ्ग को आकर कत्रो?
कोमल ओलि र धिरेन्द्र बिचको अफेयर
My new song "kaliko thumka"
भिनाजुको स्वेटर
Travelling via Europe
अब नसुध्रि शुख - आस्था राउतले डण्ठे भन्दै गालि नगरेको भए कसैले सुन्थेन ....
बिहे गर्न अगाडी प्रियांकाले आफ्ना शुभेक्छुकहरुलाई यसरी आफ्नो पोल्ने धुंवादार शरीर (smoking hot body) देखाईन
Graduating in 2020 may
Why some girls like to act like your mother instead of girlfriend
is it good to marry girl who are already in US or go back to Nepal and do arrange marriage?
This beautiful Traditional Hindu Wedding of Trusha & Neil: have your Pinterest dreams come to life
Presidential rights to assassination rights?
Funny jokes
TRUMP 2016!!! Here is why?
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.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters