Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.5.4.81 Pow
Collapse the table of content
Expand the table of content

2.5.4.81 Pow

SharePoint

The Pow function performs an exponentiation calculation.

ABNF:

Pow = val val " POW():128"

Required Arguments:

Name: Base

Type: vDouble

An argument that specifies the number to be raised to the power of Exponent.

Name: Exponent

Type: vDouble

An argument that specifies the exponent by which to raise Base.

Return Value:

Type: vNum, PtgErr

This function returns a vNum or PtgErr containing Base raised to the power of Exponent. The type of the return value is calculated by the following algorithm.

SET returnType = PtgNum

SET returnError = #NUM!

SET returnDimension = 0

IF Base.Value = 0 THEN

IF Exponent.Value = 0 THEN

SET returnType = PtgErr

SET returnError = #NUM!

ELSE IF Exponent.Value < 0 THEN

SET returnType = PtgErr

SET returnError = #DIV/0

END IF

ELSE IF Base.Value < 0 AND Exponent is not an integer THEN

SET returnType = PtgErr

SET returnError = #DIM!

ELSE IF Base.Unit = PtgNumPct THEN

SET returnType = PtgNumPct

SET returnDimension = 1

ELSE

SET returnType = Base.Unit

SET returnDimension = Base.Dimension * Exponent.Value

END IF

IF returnType = PtgErr THEN

Return type is PtgErr with error code of returnError

ELSE IF returnDimension = 0 THEN

Return type is PtgNum

ELSE IF returnDimension = 1 THEN

Return type is returnType

ELSE

Return type is PtgNumMultiDim with unit = returnType and dimension = returnDimension

END IF

Show:
© 2015 Microsoft