There must be a better way?

N

natei6

To the Excel gods,

=SQRT(A3*A3+B3*B3)

Is there a better way to write this formula?

All the best

Nathan Sargean
 
B

Biff

-----Original Message-----
To the Excel gods,

=SQRT(A3*A3+B3*B3)

Is there a better way to write this formula?
Click to expand...

What's wrong with it as it is?

=SQRT(A3^2+B3^2)

Biff
 
L

Leo Heuser

Biff said:
What's wrong with it as it is?

=SQRT(A3^2+B3^2)

Biff
Click to expand...

Nathan

For a range you may consider:

=SQRT(SUMPRODUCT((A3:H3)^2))

But it looks like Pythagoras is at large :)
 
R

Ron Rosenfeld

To the Excel gods,

=SQRT(A3*A3+B3*B3)

Is there a better way to write this formula?

All the best

Nathan Sargeant
Click to expand...

I don't know if it's better, but different:

=SQRT(SUMSQ(A3,B3))

--ron
 
B

Bob Phillips

or even

=SQRT(SUMPRODUCT((A3:B3)^2))

<vbg>

--


HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
N

natei6

Bob said:
*or even

=SQRT(SUMPRODUCT((A3:B3)^2))

<vbg>

--


HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...


Thanks everyone for the input
 
Top