ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "^" character in formula? (https://www.excelbanter.com/excel-worksheet-functions/214208-%5E-character-formula.html)

Jim

"^" character in formula?
 
Would someone tell me what the "^" character represents in a formula? Thank
you!!

Marcelo

"^" character in formula?
 
exponential

2^2 = 4
3^2 = 9

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jim" escreveu:

Would someone tell me what the "^" character represents in a formula? Thank
you!!


Michael

"^" character in formula?
 
It is the Exponent in Scientific Notation
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Jim" wrote:

Would someone tell me what the "^" character represents in a formula? Thank
you!!


Bernard Liengme

"^" character in formula?
 
In a formula like =A1^2 the caret (^) means 'raised to the power)
So if A1 has value 3, A1^2 is 3² which equals 9
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jim" wrote in message
...
Would someone tell me what the "^" character represents in a formula?
Thank
you!!





All times are GMT +1. The time now is 07:19 PM.

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