Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
E = [(a+b)^2]^1/2
Square both sides: E^2 = (a + b)^2 Take the square root of both sides: E = a + b subtract a form both sides: E - a = b Or am I missing something? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
Well done! I was being lazy - again!
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
True enough, but usually when I see this kind of construction, it is because
a calculator is being used and the person wants to get the square root whether the argument is positive or negative (usually because there is a subtraction and the person doesn't want to pay attention to the order the values being subtracted are in). As I said, usually a calculator is being used and the reason behind doing this is there is no Absolute function available. With Excel, of course, there is. Given that, I would think this expression... E: =SQRT((A1+B1)^2) would be more properly written like this instead... E: = ABS(a+b) Of course, there are still two answers as you point out, one for the possible positive value inside the ABS function and one for the possible negative value in there. Rick "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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me some Function
I don't think I wrote the beginning of my first paragraph correctly. What I
should have said is that taking the square root of a number that is squared is a method to make a value always positive (in a calculation performed on a calculator). Rick "Rick Rothstein (MVP - VB)" wrote in message ... True enough, but usually when I see this kind of construction, it is because a calculator is being used and the person wants to get the square root whether the argument is positive or negative (usually because there is a subtraction and the person doesn't want to pay attention to the order the values being subtracted are in). As I said, usually a calculator is being used and the reason behind doing this is there is no Absolute function available. With Excel, of course, there is. Given that, I would think this expression... E: =SQRT((A1+B1)^2) would be more properly written like this instead... E: = ABS(a+b) Of course, there are still two answers as you point out, one for the possible positive value inside the ABS function and one for the possible negative value in there. Rick "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |