Hello Biff,
Thank you for trying anyway.
If I get an answer I will forward it to you.
Serge

"Biff" wrote:

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?

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

"Serge" wrote in message
...
Hello Biff,
I'm back home (7pm)
I tried the "cleaned-up version" 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

"Biff" wrote:

Hi Serge!

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

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

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

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

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

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

The answer to this formula is 21.416 which is incorrect

Returns: 21.4148138423053

Matching up the ( ) to:

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

The calculator answer is 21.5407 which is correct.

Returns: 21.539294831829

Biff

"Serge" wrote in message
...
The formula below works ok in the first sheet called "Right-Angled
Triangle"
In T27
=IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),"",VLOOKUP(S27, Z4:AA84,2,1)*P27)
Lookup table is Z4:AA84

But in sheet 2 called "Oblique-Angled Triangle"
a similar formula does not work.
In U48 =IF(ISNA(VLOOKUP("T48,'Right-Angled
Triangle'!",Z4:AA84,2,1)),"","VLOOKUP(T48,'Right-Angled
Triangle'!,Z4:AA84,2,1)*Q48")
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="",B48="",C48=""),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?