3 Replies Latest reply on Aug 24, 2013 11:33 AM by tays01s

    Power function



      Power function


           The '^' works fine as a postive power function eg. 2^2= 4. However, it doesn't seem to work as a negative power eg. 2^-2=?.


           Is there a way of using '^' for a negative power? Or do I have to use the custom function?

        • 1. Re: Power function

               Put parentheses around the power and format the field with the appropriate size and number of decimal places:   2^(-2) = 0.25

               BTW, you can also use fractional powers for roots: 4^0.5 = 2

          • 2. Re: Power function

                 I tested with parentheses and without and got the correct answer .25 

                 I would guess there is another problem amiss with your calculation.

            • 3. Re: Power function

                   You are right. Unexpected since the equation is for a vital medical condition that you'd have thought people would get right (!), but it was incorrect.


                   The ^ works whether using a positive/ negative power.