software

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

Corretion

quot;Sergequot; wrote:

gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; C10=12.5 feet
gt; B27=55 degrees
gt; C37=0.9 feet
gt; answer=8.283 feet (Correct result)
gt; The above formula works.
gt;
gt; Why the formula below does not work? Does not give the correct result.
gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; I am simply changing C37 (10.8 in) into decimal of feet.
gt; Can someone help with this dilemma please?
gt; Many thanks in advance.
gt; Serge

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

quot;Sergequot; gt; wrote in message
...
gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; C10=12.5 feet
gt; B27=55 degrees
gt; C37=0.9 feet
gt; answer=8.283 feet (Correct result)
gt; The above formula works.
gt;
gt; Why the formula below does not work? Does not give the correct result.
gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; I am simply changing C37 from decimal of feet into inches
gt; Can someone help with this dilemma please?
gt; Many thanks in advance.
gt; Serge
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

quot;Sergequot; wrote:

gt; Corretion
gt;
gt; quot;Sergequot; wrote:
gt;
gt; gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; gt; C10=12.5 feet
gt; gt; B27=55 degrees
gt; gt; C37=0.9 feet
gt; gt; answer=8.283 feet (Correct result)
gt; gt; The above formula works.
gt; gt;
gt; gt; Why the formula below does not work? Does not give the correct result.
gt; gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; gt; I am simply changing C37 (10.8 in) into decimal of feet.
gt; gt; Can someone help with this dilemma please?
gt; gt; Many thanks in advance.
gt; gt; Serge


Missing bracket ...

A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27))))quot;Sergequot; wrote:

gt; Corretion
gt;
gt; quot;Sergequot; wrote:
gt;
gt; gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; gt; C10=12.5 feet
gt; gt; B27=55 degrees
gt; gt; C37=0.9 feet
gt; gt; answer=8.283 feet (Correct result)
gt; gt; The above formula works.
gt; gt;
gt; gt; Why the formula below does not work? Does not give the correct result.
gt; gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; gt; I am simply changing C37 (10.8 in) into decimal of feet.
gt; gt; Can someone help with this dilemma please?
gt; gt; Many thanks in advance.
gt; gt; Serge

Thank you so much.
I could not see the tree for the forest
Serge

quot;Toppersquot; wrote:

gt;
gt; Missing bracket ...
gt;
gt; A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27))))
gt;
gt;
gt; quot;Sergequot; wrote:
gt;
gt; gt; Corretion
gt; gt;
gt; gt; quot;Sergequot; wrote:
gt; gt;
gt; gt; gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; gt; gt; C10=12.5 feet
gt; gt; gt; B27=55 degrees
gt; gt; gt; C37=0.9 feet
gt; gt; gt; answer=8.283 feet (Correct result)
gt; gt; gt; The above formula works.
gt; gt; gt;
gt; gt; gt; Why the formula below does not work? Does not give the correct result.
gt; gt; gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; gt; gt; I am simply changing C37 (10.8 in) into decimal of feet.
gt; gt; gt; Can someone help with this dilemma please?
gt; gt; gt; Many thanks in advance.
gt; gt; gt; Serge


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: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=538178Thank you Toppers

quot;Toppersquot; wrote:

gt;
gt; Missing bracket ...
gt;
gt; A29=(C10-(C37*0.0833))/2*(TAN(RADIANS(B27))))
gt;
gt;
gt; quot;Sergequot; wrote:
gt;
gt; gt; Corretion
gt; gt;
gt; gt; quot;Sergequot; wrote:
gt; gt;
gt; gt; gt; A29=(C10-C37)/2*(TAN(RADIANS(B27)))
gt; gt; gt; C10=12.5 feet
gt; gt; gt; B27=55 degrees
gt; gt; gt; C37=0.9 feet
gt; gt; gt; answer=8.283 feet (Correct result)
gt; gt; gt; The above formula works.
gt; gt; gt;
gt; gt; gt; Why the formula below does not work? Does not give the correct result.
gt; gt; gt; A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27))))
gt; gt; gt; I am simply changing C37 (10.8 in) into decimal of feet.
gt; gt; gt; Can someone help with this dilemma please?
gt; gt; gt; Many thanks in advance.
gt; gt; gt; Serge

Hello Renegan,
You are correct, It was too late when I click 'Postquot; when I realized I made
a mistake in my explanation.
But It's all working fine now.

Thank you for your input.
Serge

quot;reneganquot; wrote:

gt;
gt; Bernard is right about parantheses but there is still an error on your
gt; formula. by multiplying C37 with 0.08333333 you don't turn it into
gt; inches, actually you don't turn it into anything. You should multiply
gt; with 12 to turn it into inches which won't work either since you cannot
gt; subtract inches from feet. I am not sure what you are trying to do by
gt; doing that multiplication on C37 but if you want to get result in
gt; inches, just multiply your result from your previous formula by 12.
gt;
gt;
gt; --
gt; renegan
gt; ------------------------------------------------------------------------
gt; renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
gt; View this thread: www.excelforum.com/showthread...hreadid=538178
gt;
gt;