ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - What is ^ in a formular? ie +(p23)^.5 (https://www.excelbanter.com/excel-discussion-misc-queries/153841-excel-what-%5E-formular-ie-p23-%5E-5-a.html)

MarcusX

Excel - What is ^ in a formular? ie +(p23)^.5
 
What is the function of the ^ symbol when used in a excel formular eg +(a5)^.5?

Box815

Excel - What is ^ in a formular? ie +(p23)^.5
 
^ is the symbol for "raised to the power of". Since it's .5 it's actually
the square root. If you wanted the square of x it would be x^2.

"MarcusX" wrote:

What is the function of the ^ symbol when used in a excel formular eg +(a5)^.5?


MarcusX

Excel - What is ^ in a formular? ie +(p23)^.5
 
Thank you very much

"Box815" wrote:

^ is the symbol for "raised to the power of". Since it's .5 it's actually
the square root. If you wanted the square of x it would be x^2.

"MarcusX" wrote:

What is the function of the ^ symbol when used in a excel formular eg +(a5)^.5?



All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com