POWER - Revision history

Admin: Created page with "= Action = Returns the power of a single or double variable and its argument
2013-02-11T21:11:33Z

Created page with "= <span class="f_Header">Action</span> = Returns the power of a single or double variable and its argument <span style="font-family: Arial;"> </span> <span style="font..."

New page
= <span class="f_Header">Action</span> =

Returns the power of a single or double variable and its argument

<span style="font-family: Arial;"> </span>

<span style="font-family: Arial;"> </span>

= <span class="f_Header">Syntax</span> =

var = <span class="f_Syntax">POWER</span>( source, raise )

<span style="font-family: Arial;"> </span>

<span style="font-family: Arial;"> </span>

= <span class="f_Header">Remarks</span> =
<div style="padding: 0px; margin: 0px 0px 0px 4px;">
{| width="539" cellspacing="0" cellpadding="1" border="1" style="border: 2px solid rgb(0, 0, 0); border-spacing: 0px; border-collapse: collapse;"
|- style="vertical-align: top;"
| valign="top" width="16%" style="width: 83px; border: 1px solid rgb(0, 0, 0);" |
Var

| valign="top" width="98%" style="width: 447px; border: 1px solid rgb(0, 0, 0);" |
A numeric variable that is assigned with the power of variable source ^ raise.

|- style="vertical-align: top;"
| valign="top" width="16%" style="width: 83px; border: 1px solid rgb(0, 0, 0);" |
Source

| valign="top" width="98%" style="width: 447px; border: 1px solid rgb(0, 0, 0);" |
The single or double variable to get the power of.

|}
</div>
<span style="font-family: Arial;"> </span>

The POWER function works for positive floating point variables only.

When you use a ^ b , the sign will be preserved.

<span style="font-family: Arial;"> </span>

While Excel does not allow raising a negative single, QB does allow it.

The Power functions uses less code compared with the code that is generated when you use ^ for floating point values.

It is important that you use single variables for both single and raise. Constants are not accepted.

 

In version 1.11.9.2 the power function is improved so that it returns the same result as Excel. Previously it returned the same number as QB/VB. For example : -2 ^ 2 would be returned as -4, but -2 ^ 3 would be returned as -8 which is wring since -2 ^ 3 = -2 x -2 x -2=4 x -2 = -8. Minus times a minutes makes a positive number. So it depends on the sign of the base and if the number of raise if even or odd.

 

The exception handling was also improved.
<div style="padding: 0px; margin: 0px;">
{| cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing: 0px; border-collapse: collapse;"
|- style="vertical-align: top;"
| valign="top" width="148" bgcolor="#ffff99" style="width: 148px; background-color: rgb(255, 255, 153); border-style: solid; border-color: rgb(0, 0, 0);" | <p style="text-align: center;"><span style="font-weight: bold;">Base</span></p>
| valign="top" width="176" bgcolor="#ffff99" style="width: 176px; background-color: rgb(255, 255, 153); border-style: solid; border-color: rgb(0, 0, 0);" | <p style="text-align: center;"><span style="font-weight: bold;">Raise</span></p>
| valign="top" width="177" bgcolor="#ffff99" style="width: 177px; background-color: rgb(255, 255, 153); border-style: solid; border-color: rgb(0, 0, 0);" | <p style="text-align: center;"><span style="font-weight: bold;">Result</span></p>
|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
x

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
x

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
Infinity

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
x

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
x

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
Infinity

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
x<0

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
Infinity

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
x>0

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
x

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
0

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
1

|- style="vertical-align: top;"
| valign="top" width="148" style="width: 148px; border-style: solid; border-color: rgb(0, 0, 0);" |
x<0

| valign="top" width="176" style="width: 176px; border-style: solid; border-color: rgb(0, 0, 0);" |
x<>int(x)

| valign="top" width="177" style="width: 177px; border-style: solid; border-color: rgb(0, 0, 0);" |
NAN

|}
</div>
 

<span style="font-family: Arial;"> </span>

<span style="font-family: Arial;"> </span>

= <span class="f_Header">See Also</span> =

[[EXP]] ,[[LOG]], [[LOG10]] , [[SQR]]

<span style="font-family: Arial;"> </span>

<span style="font-family: Arial;"> </span>

= <span class="f_Header">Example</span> =

[[FP TRIG|Show sample]]

 

 

= <span class="f_Header">Example for Double Exceptions</span> =

<br/><source lang="bascomavr">
$regfile = "m128def.dat"
$crystal = 4000000

Dim D1 As Double , D2 As Double , D3 As Double
Dim dInf as Double, dNAN as Double

d1 = -1: dNAN = log(d1)
d1 = 1: d2 = 0: dInf = D1 / D2

Print "POWER() - Test"
Print "=============="

D1 = 0: D2 = 0: GoSub ShowPowerTest

D1 = dNAN: D2 = 3: GoSub ShowPowerTest

D1 = 3: D2 = dNAN: GoSub ShowPowerTest

D1 = dInf: D2 = 4: GoSub ShowPowerTest

D1 = 4: D2 = dInf: GoSub ShowPowerTest

D1 = 0: D2 = -2: GoSub ShowPowerTest

D1 = 0: D2 = 3: GoSub ShowPowerTest

D1 = 5: D2 = 0: GoSub ShowPowerTest

D1 = -2: D2 = -3.5: GoSub ShowPowerTest

D1 = -2: D2 = 3.5: GoSub ShowPowerTest

D1 = -2: D2 = -3: GoSub ShowPowerTest

D1 = -2: D2 = -4: GoSub ShowPowerTest

D1 = -2: D2 = -5: GoSub ShowPowerTest

D1 = -2: D2 = 3: GoSub ShowPowerTest

D1 = -2: D2 = 4: GoSub ShowPowerTest

D1 = -2: D2 = 5: GoSub ShowPowerTest

end

ShowPowerTest:

D3 = POWER(D1, D2)

Print "POWER( " ; D1 ; " , " ; D2 ; ") = " ; D3

Return

--------------------------Simulator Output -------------------
POWER() - Test

==============

POWER( 0 , 0) = NAN

POWER( NAN , 3) = NAN

POWER( 3 , NAN) = NAN

POWER( Infinity , 4) = NAN

POWER( 4 , Infinity) = NAN

POWER( 0 , -2) = Infinity

POWER( 0 , 3) = 0

POWER( 5 , 0) = 1

POWER( -2 , -3.5) = NAN

POWER( -2 , 3.5) = NAN

POWER( -2 , -3) = -125E-3

POWER( -2 , -4) = 62.5E-3

POWER( -2 , -5) = -31.25E-3

POWER( -2 , 3) = -8

POWER( -2 , 4) = 16

POWER( -2 , 5) = -32
</source><br/>{{Languages}}

[[Category:BASCOM Language Reference]]