WorksheetFunction.Power Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the result of a number raised to a power.

expression .Power(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Number - the base number. It can be any real number.

Arg2

Required

Double

Power - the exponent to which the base number is raised.

Return Value

Double

The "^" operator can be used instead of POWER to indicate to what power the base number is to be raised, such as in 5^2.

Show: