[dba-Tech] Excel question

Lol.  I know, I know.  But to use an exponential formula , as in = $A$1 ^
$A$2...


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, August 04, 2012 4:19 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Excel question

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