software

The formula below works ok in the first sheet called quot;Right-Angled Trianglequot;
In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
Lookup table is Z4:AA84

But in sheet 2 called quot;Oblique-Angled Trianglequot;
a similar formula does not work.
In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
Triangle'!,Z4:AA84,2,1)*Q48quot;)
I am trying to use the same table for both sheets.

also one more question if it's ok.
I'm not getting the correct answer?
In A48, B48, C48 will be user input which will be empty at the beginning.
In E48
=IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
The answer to this formula is 21.416 which is incorrect
Oblique Triangle solution:
Side a in A48=25.0
Angle A in B48=79.94 Degrees
Angle B in C48=58.03 Degrees

Side 'b' = a x sin 'B' / sin 'A'
The calculator answer is 21.5407 which is correct.

What am I doing wrong?
Hi Serge!

Your second lookup formula has some double quotes (quot;) and some commas (,)
that are causing the problem. Try this cleaned-up version:

=IF(ISNA(VLOOKUP(T48,'Right-Angled
Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
Triangle'!Z4:AA84,2,1)*Q48)

gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; The answer to this formula is 21.416 which is incorrect
gt; The calculator answer is 21.5407 which is correct.

If the values referencd are user input and not calculated........

You have a misplaced quot;)quot; which changes the precedence of the calculation:

=IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))

gt; The answer to this formula is 21.416 which is incorrect

Returns: 21.4148138423053

Matching up the ( ) to:

=IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*SIN(RADIANS(C48 ))/SIN(RADIANS(B48)))

gt; The calculator answer is 21.5407 which is correct.

Returns: 21.539294831829

Biff

quot;Sergequot; gt; wrote in message
...
gt; The formula below works ok in the first sheet called quot;Right-Angled
gt; Trianglequot;
gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
gt; Lookup table is Z4:AA84
gt;
gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; a similar formula does not work.
gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; I am trying to use the same table for both sheets.
gt;
gt; also one more question if it's ok.
gt; I'm not getting the correct answer?
gt; In A48, B48, C48 will be user input which will be empty at the beginning.
gt; In E48
gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; The answer to this formula is 21.416 which is incorrect
gt; Oblique Triangle solution:
gt; Side a in A48=25.0
gt; Angle A in B48=79.94 Degrees
gt; Angle B in C48=58.03 Degrees
gt;
gt; Side 'b' = a x sin 'B' / sin 'A'
gt; The calculator answer is 21.5407 which is correct.
gt;
gt; What am I doing wrong?
gt;
gt;
quot;Sergequot; wrote:
gt; The formula below works ok in the first sheet called quot;Right-Angled Trianglequot;
gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,
gt; VLOOKUP(S27,Z4:AA84,2,1)*P27). Lookup table is Z4:AA84
gt;
gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; a similar formula does not work.
gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; I am trying to use the same table for both sheets.

Some thoughts for the above ..

In sheet: Oblique-Angled Triangle

Try this in U48:
=IF(ISNA(VLOOKUP(T48,'Right-Angled
Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
Triangle'!Z4:AA84,2,1)*Q48)

Alternatively, it might be easier to create a defined name for the
table_array (in sheet: Right-Angled Triangle) which could then be referred to
in any sheet in the book

One quick way* to create a defined name ..

In sheet: Right-Angled Triangle

Select Z4:AA84 (i.e. the table_array),
then click inside the namebox
(box with the drop-arrow just to the left of the formula bar)
Key-in a name, say: MyTable
then press Enter

Then in sheet: Oblique-Angled Triangle
we could put this shorter version in U48:
=IF(ISNA(VLOOKUP(T48,MyTable,2,1)),quot;quot;,VLOOKUP(T48, MyTable,2,1)*Q48)

*the normal way would be via clicking Insert gt; Name gt; Define
(Options to create and delete defined names are there. Note that we can't
use the namebox to delete defined names, only to create.)

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Hello Biff,
Its 6:15 am.just before going to work.
I tried for more than two hours last without any luck.
Thank you for your reply, I will try your version and get back to you.

Thank you very much.
Serge
ps; I would like to adopt you as a brother.

quot;Biffquot; wrote:

gt; Hi Serge!
gt;
gt; Your second lookup formula has some double quotes (quot;) and some commas (,)
gt; that are causing the problem. Try this cleaned-up version:
gt;
gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)*Q48)
gt;
gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt; The calculator answer is 21.5407 which is correct.
gt;
gt; If the values referencd are user input and not calculated........
gt;
gt; You have a misplaced quot;)quot; which changes the precedence of the calculation:
gt;
gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt;
gt; gt; The answer to this formula is 21.416 which is incorrect
gt;
gt; Returns: 21.4148138423053
gt;
gt; Matching up the ( ) to:
gt;
gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*SIN(RADIANS(C48 ))/SIN(RADIANS(B48)))
gt;
gt; gt; The calculator answer is 21.5407 which is correct.
gt;
gt; Returns: 21.539294831829
gt;
gt; Biff
gt;
gt; quot;Sergequot; gt; wrote in message
gt; ...
gt; gt; The formula below works ok in the first sheet called quot;Right-Angled
gt; gt; Trianglequot;
gt; gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
gt; gt; Lookup table is Z4:AA84
gt; gt;
gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; gt; a similar formula does not work.
gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; gt; I am trying to use the same table for both sheets.
gt; gt;
gt; gt; also one more question if it's ok.
gt; gt; I'm not getting the correct answer?
gt; gt; In A48, B48, C48 will be user input which will be empty at the beginning.
gt; gt; In E48
gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt; Oblique Triangle solution:
gt; gt; Side a in A48=25.0
gt; gt; Angle A in B48=79.94 Degrees
gt; gt; Angle B in C48=58.03 Degrees
gt; gt;
gt; gt; Side 'b' = a x sin 'B' / sin 'A'
gt; gt; The calculator answer is 21.5407 which is correct.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt;
gt;
gt;
gt;

Hello Max,
Thank you very much for your input. I will try that first chance I get and
give you some feed back.
Serge

quot;Maxquot; wrote:

gt; quot;Sergequot; wrote:
gt; gt; The formula below works ok in the first sheet called quot;Right-Angled Trianglequot;
gt; gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,
gt; gt; VLOOKUP(S27,Z4:AA84,2,1)*P27). Lookup table is Z4:AA84
gt; gt;
gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; gt; a similar formula does not work.
gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; gt; I am trying to use the same table for both sheets.
gt;
gt; Some thoughts for the above ..
gt;
gt; In sheet: Oblique-Angled Triangle
gt;
gt; Try this in U48:
gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)*Q48)
gt;
gt; Alternatively, it might be easier to create a defined name for the
gt; table_array (in sheet: Right-Angled Triangle) which could then be referred to
gt; in any sheet in the book
gt;
gt; One quick way* to create a defined name ..
gt;
gt; In sheet: Right-Angled Triangle
gt;
gt; Select Z4:AA84 (i.e. the table_array),
gt; then click inside the namebox
gt; (box with the drop-arrow just to the left of the formula bar)
gt; Key-in a name, say: MyTable
gt; then press Enter
gt;
gt; Then in sheet: Oblique-Angled Triangle
gt; we could put this shorter version in U48:
gt; =IF(ISNA(VLOOKUP(T48,MyTable,2,1)),quot;quot;,VLOOKUP(T48, MyTable,2,1)*Q48)
gt;
gt; *the normal way would be via clicking Insert gt; Name gt; Define
gt; (Options to create and delete defined names are there. Note that we can't
gt; use the namebox to delete defined names, only to create.)
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---

Hello Biff,
I'm back home (7pm)
I tried the quot;cleaned-up versionquot; and it works fine now. Thanks again.

I'm working on another Triangle solution which I have a bit of trouble with.
In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
To represent: tan A = a x sin C / b - (a x cos C)
a=25.0 in A51
b=21.5407 in B51
Angle C=42.03 Degrees in C51
Answer should be 79.935 degrees.

could you help with this one as well?

Much appreciation
Serge

quot;Biffquot; wrote:

gt; Hi Serge!
gt;
gt; Your second lookup formula has some double quotes (quot;) and some commas (,)
gt; that are causing the problem. Try this cleaned-up version:
gt;
gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)*Q48)
gt;
gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt; The calculator answer is 21.5407 which is correct.
gt;
gt; If the values referencd are user input and not calculated........
gt;
gt; You have a misplaced quot;)quot; which changes the precedence of the calculation:
gt;
gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt;
gt; gt; The answer to this formula is 21.416 which is incorrect
gt;
gt; Returns: 21.4148138423053
gt;
gt; Matching up the ( ) to:
gt;
gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*SIN(RADIANS(C48 ))/SIN(RADIANS(B48)))
gt;
gt; gt; The calculator answer is 21.5407 which is correct.
gt;
gt; Returns: 21.539294831829
gt;
gt; Biff
gt;
gt; quot;Sergequot; gt; wrote in message
gt; ...
gt; gt; The formula below works ok in the first sheet called quot;Right-Angled
gt; gt; Trianglequot;
gt; gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
gt; gt; Lookup table is Z4:AA84
gt; gt;
gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; gt; a similar formula does not work.
gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; gt; I am trying to use the same table for both sheets.
gt; gt;
gt; gt; also one more question if it's ok.
gt; gt; I'm not getting the correct answer?
gt; gt; In A48, B48, C48 will be user input which will be empty at the beginning.
gt; gt; In E48
gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt; Oblique Triangle solution:
gt; gt; Side a in A48=25.0
gt; gt; Angle A in B48=79.94 Degrees
gt; gt; Angle B in C48=58.03 Degrees
gt; gt;
gt; gt; Side 'b' = a x sin 'B' / sin 'A'
gt; gt; The calculator answer is 21.5407 which is correct.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt;
gt;
gt;
gt;

Hello Max,
(I'm back home, It's 7:30 pm Pacific)
I changed my formula to match yours with proper name for the TABLE and it
works great.
I did something similar not too long ago, but I could not remember I to do it.
At the age of nearly 63, sometime I forget to remember to take my memory pill.
I am very glad you could help.
Thanks
Serge

quot;Maxquot; wrote:

gt; quot;Sergequot; wrote:
gt; gt; The formula below works ok in the first sheet called quot;Right-Angled Trianglequot;
gt; gt; In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,
gt; gt; VLOOKUP(S27,Z4:AA84,2,1)*P27). Lookup table is Z4:AA84
gt; gt;
gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; gt; a similar formula does not work.
gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; gt; I am trying to use the same table for both sheets.
gt;
gt; Some thoughts for the above ..
gt;
gt; In sheet: Oblique-Angled Triangle
gt;
gt; Try this in U48:
gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt; Triangle'!Z4:AA84,2,1)*Q48)
gt;
gt; Alternatively, it might be easier to create a defined name for the
gt; table_array (in sheet: Right-Angled Triangle) which could then be referred to
gt; in any sheet in the book
gt;
gt; One quick way* to create a defined name ..
gt;
gt; In sheet: Right-Angled Triangle
gt;
gt; Select Z4:AA84 (i.e. the table_array),
gt; then click inside the namebox
gt; (box with the drop-arrow just to the left of the formula bar)
gt; Key-in a name, say: MyTable
gt; then press Enter
gt;
gt; Then in sheet: Oblique-Angled Triangle
gt; we could put this shorter version in U48:
gt; =IF(ISNA(VLOOKUP(T48,MyTable,2,1)),quot;quot;,VLOOKUP(T48, MyTable,2,1)*Q48)
gt;
gt; *the normal way would be via clicking Insert gt; Name gt; Define
gt; (Options to create and delete defined names are there. Note that we can't
gt; use the namebox to delete defined names, only to create.)
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---

You're welcome, Serge !
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Sergequot; wrote:
gt; Hello Max,
gt; Thank you very much for your input. I will try that first chance I get and
gt; give you some feed back.
gt; Serge

gt; In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
gt; To represent: tan A = a x sin C / b - (a x cos C)
gt; a=25.0 in A51
gt; b=21.5407 in B51
gt; Angle C=42.03 Degrees in C51
gt; Answer should be 79.935 degrees.
gt;
gt; could you help with this one as well?

Not having any luck with that one. I don't know much about trig but no
matter how I change the precedence I'm not getting anything close to 79.935.

Biff

quot;Sergequot; gt; wrote in message
...
gt; Hello Biff,
gt; I'm back home (7pm)
gt; I tried the quot;cleaned-up versionquot; and it works fine now. Thanks again.
gt;
gt; I'm working on another Triangle solution which I have a bit of trouble
gt; with.
gt; In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
gt; To represent: tan A = a x sin C / b - (a x cos C)
gt; a=25.0 in A51
gt; b=21.5407 in B51
gt; Angle C=42.03 Degrees in C51
gt; Answer should be 79.935 degrees.
gt;
gt; could you help with this one as well?
gt;
gt; Much appreciation
gt; Serge
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi Serge!
gt;gt;
gt;gt; Your second lookup formula has some double quotes (quot;) and some commas (,)
gt;gt; that are causing the problem. Try this cleaned-up version:
gt;gt;
gt;gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt;gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt;gt; Triangle'!Z4:AA84,2,1)*Q48)
gt;gt;
gt;gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt;gt;
gt;gt; If the values referencd are user input and not calculated........
gt;gt;
gt;gt; You have a misplaced quot;)quot; which changes the precedence of the
gt;gt; calculation:
gt;gt;
gt;gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt;gt;
gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt;gt;
gt;gt; Returns: 21.4148138423053
gt;gt;
gt;gt; Matching up the ( ) to:
gt;gt;
gt;gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*SIN(RADIANS(C48 ))/SIN(RADIANS(B48)))
gt;gt;
gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt;gt;
gt;gt; Returns: 21.539294831829
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Sergequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The formula below works ok in the first sheet called quot;Right-Angled
gt;gt; gt; Trianglequot;
gt;gt; gt; In T27
gt;gt; gt; =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
gt;gt; gt; Lookup table is Z4:AA84
gt;gt; gt;
gt;gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt;gt; gt; a similar formula does not work.
gt;gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt;gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt;gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt;gt; gt; I am trying to use the same table for both sheets.
gt;gt; gt;
gt;gt; gt; also one more question if it's ok.
gt;gt; gt; I'm not getting the correct answer?
gt;gt; gt; In A48, B48, C48 will be user input which will be empty at the
gt;gt; gt; beginning.
gt;gt; gt; In E48
gt;gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt;gt; gt; Oblique Triangle solution:
gt;gt; gt; Side a in A48=25.0
gt;gt; gt; Angle A in B48=79.94 Degrees
gt;gt; gt; Angle B in C48=58.03 Degrees
gt;gt; gt;
gt;gt; gt; Side 'b' = a x sin 'B' / sin 'A'
gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt;gt; gt;
gt;gt; gt; What am I doing wrong?
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Hello Biff,
Thank you for trying anyway.
If I get an answer I will forward it to you.
Serge

quot;Biffquot; wrote:

gt; gt; In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
gt; gt; To represent: tan A = a x sin C / b - (a x cos C)
gt; gt; a=25.0 in A51
gt; gt; b=21.5407 in B51
gt; gt; Angle C=42.03 Degrees in C51
gt; gt; Answer should be 79.935 degrees.
gt; gt;
gt; gt; could you help with this one as well?
gt;
gt; Not having any luck with that one. I don't know much about trig but no
gt; matter how I change the precedence I'm not getting anything close to 79.935.
gt;
gt; Biff
gt;
gt; quot;Sergequot; gt; wrote in message
gt; ...
gt; gt; Hello Biff,
gt; gt; I'm back home (7pm)
gt; gt; I tried the quot;cleaned-up versionquot; and it works fine now. Thanks again.
gt; gt;
gt; gt; I'm working on another Triangle solution which I have a bit of trouble
gt; gt; with.
gt; gt; In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
gt; gt; To represent: tan A = a x sin C / b - (a x cos C)
gt; gt; a=25.0 in A51
gt; gt; b=21.5407 in B51
gt; gt; Angle C=42.03 Degrees in C51
gt; gt; Answer should be 79.935 degrees.
gt; gt;
gt; gt; could you help with this one as well?
gt; gt;
gt; gt; Much appreciation
gt; gt; Serge
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi Serge!
gt; gt;gt;
gt; gt;gt; Your second lookup formula has some double quotes (quot;) and some commas (,)
gt; gt;gt; that are causing the problem. Try this cleaned-up version:
gt; gt;gt;
gt; gt;gt; =IF(ISNA(VLOOKUP(T48,'Right-Angled
gt; gt;gt; Triangle'!Z4:AA84,2,1)),quot;quot;,VLOOKUP(T48,'Right-Angled
gt; gt;gt; Triangle'!Z4:AA84,2,1)*Q48)
gt; gt;gt;
gt; gt;gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt; gt;gt;
gt; gt;gt; If the values referencd are user input and not calculated........
gt; gt;gt;
gt; gt;gt; You have a misplaced quot;)quot; which changes the precedence of the
gt; gt;gt; calculation:
gt; gt;gt;
gt; gt;gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt;gt;
gt; gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt;gt;
gt; gt;gt; Returns: 21.4148138423053
gt; gt;gt;
gt; gt;gt; Matching up the ( ) to:
gt; gt;gt;
gt; gt;gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*SIN(RADIANS(C48 ))/SIN(RADIANS(B48)))
gt; gt;gt;
gt; gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt; gt;gt;
gt; gt;gt; Returns: 21.539294831829
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Sergequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; The formula below works ok in the first sheet called quot;Right-Angled
gt; gt;gt; gt; Trianglequot;
gt; gt;gt; gt; In T27
gt; gt;gt; gt; =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),quot;quot;,VLOOKUP(S27, Z4:AA84,2,1)*P27)
gt; gt;gt; gt; Lookup table is Z4:AA84
gt; gt;gt; gt;
gt; gt;gt; gt; But in sheet 2 called quot;Oblique-Angled Trianglequot;
gt; gt;gt; gt; a similar formula does not work.
gt; gt;gt; gt; In U48 =IF(ISNA(VLOOKUP(quot;T48,'Right-Angled
gt; gt;gt; gt; Triangle'!quot;,Z4:AA84,2,1)),quot;quot;,quot;VLOOKUP(T48,'Right-Angled
gt; gt;gt; gt; Triangle'!,Z4:AA84,2,1)*Q48quot;)
gt; gt;gt; gt; I am trying to use the same table for both sheets.
gt; gt;gt; gt;
gt; gt;gt; gt; also one more question if it's ok.
gt; gt;gt; gt; I'm not getting the correct answer?
gt; gt;gt; gt; In A48, B48, C48 will be user input which will be empty at the
gt; gt;gt; gt; beginning.
gt; gt;gt; gt; In E48
gt; gt;gt; gt; =IF(OR(A48=quot;quot;,B48=quot;quot;,C48=quot;quot;),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48))))))
gt; gt;gt; gt; The answer to this formula is 21.416 which is incorrect
gt; gt;gt; gt; Oblique Triangle solution:
gt; gt;gt; gt; Side a in A48=25.0
gt; gt;gt; gt; Angle A in B48=79.94 Degrees
gt; gt;gt; gt; Angle B in C48=58.03 Degrees
gt; gt;gt; gt;
gt; gt;gt; gt; Side 'b' = a x sin 'B' / sin 'A'
gt; gt;gt; gt; The calculator answer is 21.5407 which is correct.
gt; gt;gt; gt;
gt; gt;gt; gt; What am I doing wrong?
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;