multiple formual'a that equal the same thing
 

i'm trying to write a formula that will figure out an angle for me useing
trig. the number always change for the math and i don't always have the same
info.

this is what the graph looks like now
c d e f
angle leg opp leg hyp leg adj
0.0625 0.148 0.134

to find c36
these are the posible formula's
=DEGREES(ASIN(D36/E36))
=DEGREES(ACOS(F36/E36))
=degrees(atan(D36/F36))

i need a formula that has all these formula's in it but it only uses one to
get the answer, using the info i have, but ignores the others if the info
isn't there.

multiple formual'a that equal the same thing
 

Machinist,

You could use

=IF(COUNTA(D36:F36)<2,"",IF(F36="",DEGREES(ASIN(D3 6/E36)),IF(E36="",DEGREES(ATAN(D36/F36)),DEGREES(ACOS(F36/E36)))))

But note that with your values, you get three different answers, since they
are rounded values, and don't quite fulfill the Pythagorean requirements to
actually form a right triangle.

HTH,
Bernie
MS Excel MVP


"machinist 101" wrote in message
...
i'm trying to write a formula that will figure out an angle for me useing
trig. the number always change for the math and i don't always have the
same
info.

this is what the graph looks like now
c d e f
angle leg opp leg hyp leg adj
0.0625 0.148 0.134

to find c36
these are the posible formula's
=DEGREES(ASIN(D36/E36))
=DEGREES(ACOS(F36/E36))
=degrees(atan(D36/F36))

i need a formula that has all these formula's in it but it only uses one
to
get the answer, using the info i have, but ignores the others if the info
isn't there.

multiple formual'a that equal the same thing
 

THANK YOU!!!!!

i have been working on this for 2days now and this worked out perfectly.


"Bernie Deitrick" wrote:

Machinist,

You could use

=IF(COUNTA(D36:F36)<2,"",IF(F36="",DEGREES(ASIN(D3 6/E36)),IF(E36="",DEGREES(ATAN(D36/F36)),DEGREES(ACOS(F36/E36)))))

But note that with your values, you get three different answers, since they
are rounded values, and don't quite fulfill the Pythagorean requirements to
actually form a right triangle.

HTH,
Bernie
MS Excel MVP


"machinist 101" wrote in message
...
i'm trying to write a formula that will figure out an angle for me useing
trig. the number always change for the math and i don't always have the
same
info.

this is what the graph looks like now
c d e f
angle leg opp leg hyp leg adj
0.0625 0.148 0.134

to find c36
these are the posible formula's
=DEGREES(ASIN(D36/E36))
=DEGREES(ACOS(F36/E36))
=degrees(atan(D36/F36))

i need a formula that has all these formula's in it but it only uses one
to
get the answer, using the info i have, but ignores the others if the info
isn't there.