Excel help again!!

OK so I'm trying to figure out how to enter in the formula for tangent , opp/adj=tangent.

I know how to enter that part, but how do I get it to show the angle is zero if it's really zero? I know I need to use =if..... But i'm lost as soon as I enter that.

Here's a picture of what I'm trying to do. We have the distance (the opposite) and we have the offset (adj)




Sent from my iPhone using Tapatalk

 

Isn't there supposed to be another = whatever after the ()

 

If you don't get an answer by tomorrow mid morning PM me and remind me and I'll help. I'll probably forget. I can't help anymore tonight.

 

There is a tangent function

=TAN(RADIANS(number))

So the tangent in degrees of 45 would be =TAN(RADIANS(45))

Also remember that you can not divide by zero.

I am not sure if that helps you here though.

To check for zero you could something like this

Say B2 is 50 and C2 is 0

=IF(C2=0,0,B2/C2)

Hope that helps

 

Thanks I appreciate it!

Awesome, thank you!! I'll give that a shot!!


Sent from my iPhone using Tapatalk