Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
A29=(C10-C37)/2*(TAN(RADIANS(B27)))
C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 from decimal of feet into inches Can someone help with this dilemma please? Many thanks in advance. Serge |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Corretion
"Serge" wrote: A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 (10.8 in) into decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
It all in the parentheses!
This A29=(C10-C37)/2*(TAN(RADIANS(B27))) could be coded as A29=(C10-C37)/2*TAN(RADIANS(B27)) But this A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) should be A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27))) or A29=(C10-(C37*0.0833))/2*TAN(RADIANS(B27)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Serge" wrote in message ... A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 from decimal of feet into inches Can someone help with this dilemma please? Many thanks in advance. Serge |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
A29=(C10-C37)/2*(TAN(RADIANS(B27)))
C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 to 10.8 inches to decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge "Serge" wrote: Corretion "Serge" wrote: A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 (10.8 in) into decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Missing bracket ... A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27)))) "Serge" wrote: Corretion "Serge" wrote: A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 (10.8 in) into decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Thank you so much.
I could not see the tree for the forest Serge "Toppers" wrote: Missing bracket ... A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27)))) "Serge" wrote: Corretion "Serge" wrote: A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 (10.8 in) into decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Bernard is right about parantheses but there is still an error on your formula. by multiplying C37 with 0.08333333 you don't turn it into inches, actually you don't turn it into anything. You should multiply with 12 to turn it into inches which won't work either since you cannot subtract inches from feet. I am not sure what you are trying to do by doing that multiplication on C37 but if you want to get result in inches, just multiply your result from your previous formula by 12. -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=538178 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Thank you Toppers
"Toppers" wrote: Missing bracket ... A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27)))) "Serge" wrote: Corretion "Serge" wrote: A29=(C10-C37)/2*(TAN(RADIANS(B27))) C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 (10.8 in) into decimal of feet. Can someone help with this dilemma please? Many thanks in advance. Serge |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
Hello Renegan,
You are correct, It was too late when I click 'Post" when I realized I made a mistake in my explanation. But It's all working fine now. Thank you for your input. Serge "renegan" wrote: Bernard is right about parantheses but there is still an error on your formula. by multiplying C37 with 0.08333333 you don't turn it into inches, actually you don't turn it into anything. You should multiply with 12 to turn it into inches which won't work either since you cannot subtract inches from feet. I am not sure what you are trying to do by doing that multiplication on C37 but if you want to get result in inches, just multiply your result from your previous formula by 12. -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=538178 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Excel Math problem | Excel Worksheet Functions | |||
Excel Math formulas | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) |