[dba-Tech] Excel question

Kewl Do you have any idea what what have just verified? Think deeply about
this. It is non-trivial. This concerns Fermat's Last Theorem.

On Sat, Aug 4, 2012 at 4:18 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> You don't "have" to.
>
> =(A1^2+B1^2)^2  and
> =(A1^2 -B1^2)^2 + (2*A1*B1)^2
> work for me. They both return 169 when cell A1 contains 2 and cell B1
> contains 3.
>
> Similarly =A1^B1 returns 8
>
> --
> Stuart
>
> On 4 Aug 2012 at 13:12, Bobby Heid wrote:
>
> > You have to use the Power function
> > 5^3
> > =POWER(5,3)
> >
> > So (x^2 + y^2)^2 would be
> > =power(power(x,2) +power(y,2),2)
> >
> > Bobby
> >
> > -----Original Message-----
> > From: dba-tech-bounces at databaseadvisors.com
> > [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur
> Fuller
> > Sent: Saturday, August 04, 2012 7:04 AM
> > To: Discussion of Hardware and Software issues
> > Subject: [dba-Tech] Excel question
> >
> > Hi all,
> >
> > I ought to know this, but don't. Call me stupid or at best ignorant. How
> > does one enter a formula involving exponents? I want to enter these
> > formulae, using pseudo-syntax:
> >
> > (x^2 + y^2)^2
> > (x^2 - y^2)^2 + (2xy)^2
> >
> > Where the caret represents Power of, so x^2 means x squared, and x and y
> > represent cell locations that contain arbitrary values.
> >
> > Can you help?
> > TIA!
> >
> > --
> > Arthur
> > Cell: 647.710.1314
> >
> > Prediction is difficult, especially of the future.
> >   -- Niels Bohr
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr