RE: {Spam?} RE: [OT] Excel/maths question

["White, Peter" <peter.white@xxxxxxxxxxxxx>]

Thanks guys, you're all pub geniuses.

Pete

-----Original Message-----
From: Ward, David [mailto:DAvid.Ward@xxxxxxx]
Sent: 23 March 2004 12:13
To: 'ukha_d@xxxxxxx'
Subject: {Spam?} RE: [ukha_d] [OT] Excel/maths question


\o/  I got it right!

/jumps around like a child - nods to office full of staring people &
returns
to seat quietly/

Dave

-----Original Message-----
From: Ward, David [mailto:DAvid.Ward@xxxxxxx]
Sent: 23 March 2004 12:06
To: 'ukha_d@xxxxxxx'
Subject: RE: [ukha_d] [OT] Excel/maths question


SQRT()  should give you the squareroot

Area of a circle is PI x Radius x Radius

so in your example 424 = PI x Radius x Radius

Radius = SQRT (424 / PI())

so your diameter is 2 * (SQRT(424 /PI()))


HTH

Dave

PS can someone check the maths ;-)





-----Original Message-----
From: White, Peter [mailto:peter.white@xxxxxxx]
Sent: 23 March 2004 11:46
To: 'ukha_d@xxxxxxx'
Subject: [ukha_d] [OT] Excel/maths question


It's been at east a month since I asked an Excel question ;-)

This one should be easy for the maths guru's out there, if I've got a
square
area of 424km (for example), how do I work out the dimensions of the
square,
or, even better, the diameter of a circle based on 424km/sq.

Thanks

______________________________________________
Pete White


[Non-text portions of this message have been removed]




UK Home Automation Meet 2004 - BOOK NOW!
http://www.ukha2004.com <http://www.ukha2004.com>

http://www.automatedhome.co.uk
<http://www.automatedhome.co.uk>

Member Offers - http://www.freeranger.co.uk/ukha
<http://www.freeranger.co.uk/ukha>