![caret math caret math](https://ak1.ostkcdn.com/images/products/is/images/direct/aea6264f3d92f682f0eb4261604299ba8bdedf50/Math-Of-Mathematics-Drawings-Doodle-Symbol-Education-Equation-Pattern-Garden-Flag-Decorative-Flag-House-Banner-12X18-Inc.jpg)
If the base is negative the exponent must be integer only. The next point is about the negative numbers as the base in Power. See the example below where the ArrayFormula also got invloved. The above two functions and the Caret work in an Array too. The above are the 3 options to multiply a number by a Power in Google Sheets. You can raise a number to a power using ^ as below. This works both in Excel and Google Sheets. But I am unsure about the availability in the latest iteration of Excel.Įxample to the Usage of Pow Function in Google Sheets: =POW(10,3) Multiply a Number by a Power Using the Caret Actually, both Power and Pow are the same.Īs far as I know, there is only the Power() function in Excel. You can replicate the same example using the Pow() function in Google Sheets. The result would be 1000 which is equal to =10*10*10 Multiply a Number by a Power Using the Pow() Function Multiply a Number by a Power Using the Power() FunctionĮxample to the Usage of Power Function in Google Sheets: =POWER(10,3) When you are multiplying a number by a Power, what you are really doing is multiplying that number (base) by itself a number of times equal to the power (exponent). Use the Power, Pow functions or the Caret to return a base number raised to an exponent power.
#CARET MATH HOW TO#
How to Multiply a Number by a Power in Google Sheets Let me explain to you how to multiply a number by a Power in Google Sheets using the functions and the symbol. While the Power() is categorized as a Math function in Google Sheets the Pow() is categorized under Operator. Other than these two functions there is the Caret ^ Symbol that does the same thing. There are two functions to multiply a number by a Power in Google Sheets.