Squares etc.

  • Thread starter Thread starter Me
  • Start date Start date
M

Me

Is there a way to build a formula where one is searching for a number
squared or cubed etc. Can't figure out one might write it.
 
Don't know if I understand your question but,
if you enter:
=2^2
you will get 4, and
=3^3
and you will get 27.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to build a formula where one is searching for a number
squared or cubed etc. Can't figure out one might write it.
 
Dear Steve
You could build an if statement using rag's method ie if
(A2=A1^A1,"True,"False"), or you could do it in reverse if
you already have an answer and are looking to see if your
cell is the square root, you could use if(A2=sqrt
(A1),"true","False)

Hope this helps
 
To add to that, you can write:

=A2 ^ 2
=2 ^ A2
=A2 ^ B2

and all kinds of stuff like that.
 
Back
Top