mmmmm.....

So that was what I was missing. <g

I know that this is an XL NG not a maths one and I accept that the maths
does work out but does that mean that it is possible to resolve:

E = [(a+b)^2]^1/2

into

b = -a - e


--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dana DeLouis" wrote in message
...
b = E-a

Don't forget there is a Square function also, so most likely two
solutions: :)

b = -a + e
OR
b = -a - e

(ie b could be -7, or +1)

a=3
b=-7
?((a+b)^2)^(1/2)
4

b=1
?((a+b)^2)^(1/2)
4

--
:)
Dana DeLouis


"Bernard Liengme" wrote in message
...
Just to confirm what Sandy said:
E = [(a+b)^2]^1/2
simplify right side (which says square and then square root - these
cancel each other)
E = (a+b)
b = E-a
Don't let Excel blind you so that the math gets lost!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Krisda" wrote in message
...
from E = [(a+b)^2]^1/2
write in excel is " =sqrt((a1+b1)^2) "

but I need to find a volume of "b" but,I have a "E" and "a"
How to writr a function for excel to calculate to give a volume of "b"

Regards