what does the symbol "^" mean and how can it be represented in a f

P

Peo Sjoblom

"in a f"? Why not take the time to write a proper question in the body of
the message?

If you meant in a function like =A1^2 then it means A1 to the power of 2 can
also be written

=POWER(A1,2)

--
Regards,

Peo Sjoblom

Portland, Oregon
 
J

JE McGimpsey

Hard to tell what you're asking for, since you didn't put the question
in the body of the message.

The answer to the first part of the question is that "^" is the carat
character, and, in XL formulas, represents exponentiation. So

=2^3 returns 8 (2 to the 3rd power)
=3^2 returns 9 (3 to the 2nd power)

"Chad" <[email protected]> wrote:
 
Top