There must be a better way?

  • Thread starter Thread starter natei6
  • Start date Start date
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
 
-----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
 
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 :-)
 
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
 
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)
 
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
 
Back
Top