G Guest Aug 25, 2004 #1 In excel, how would one calculate the inverse of TAN (ie. TAN^-1)? Thank you.
H hgrove Aug 25, 2004 #3 Jerry W. Lewis wrote... ATAN Click to expand... ... ATAN2 is more flexible. For finite tangents, =ATAN2(TanVal,1) For infinite tangents (from angles of odd integer multiples of PI/2), =ATAN2(0,1) or =ATAN2(0,-1
Jerry W. Lewis wrote... ATAN Click to expand... ... ATAN2 is more flexible. For finite tangents, =ATAN2(TanVal,1) For infinite tangents (from angles of odd integer multiples of PI/2), =ATAN2(0,1) or =ATAN2(0,-1
J Jerry W. Lewis Aug 26, 2004 #4 I never noticed that it existed; thanks. Jerry Jerry W. Lewis wrote... .. ATAN2 is more flexible. For finite tangents, =ATAN2(TanVal,1) For infinite tangents (from angles of odd integer multiples of PI/2), =ATAN2(0,1) or =ATAN2(0,-1) Click to expand...
I never noticed that it existed; thanks. Jerry Jerry W. Lewis wrote... .. ATAN2 is more flexible. For finite tangents, =ATAN2(TanVal,1) For infinite tangents (from angles of odd integer multiples of PI/2), =ATAN2(0,1) or =ATAN2(0,-1) Click to expand...
