- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Need excel help.......
Posted on 8/23/17 at 6:55 pm
Posted on 8/23/17 at 6:55 pm
Simple problem that has me baffled.
I'm trying to get the inverse tangent of a number in degrees in an excel spreadsheet. I have a cell that has the opposite divided by the adjacent. I've tried ATAN= and ATANH= as well as different format for the number in the cell and I'm not getting the right answer.
What am I missing?
TIA
I'm trying to get the inverse tangent of a number in degrees in an excel spreadsheet. I have a cell that has the opposite divided by the adjacent. I've tried ATAN= and ATANH= as well as different format for the number in the cell and I'm not getting the right answer.
What am I missing?
TIA
Posted on 8/23/17 at 7:13 pm to Geaux-2-L-O-Miss
Try using 1/tan as the workaround.
Posted on 8/23/17 at 7:26 pm to Bestbank Tiger
Tried it but it didn't work. Thanks anyway.
Posted on 8/23/17 at 7:34 pm to Geaux-2-L-O-Miss
Maybe use a formula to convert degrees to radians and take the arctangent of that?
Posted on 8/23/17 at 7:46 pm to Bestbank Tiger
That put me on the right track, thanks.
Took the ATAN in one cell then converted to degrees in the next cell.
Took the ATAN in one cell then converted to degrees in the next cell.
Posted on 8/23/17 at 7:55 pm to Geaux-2-L-O-Miss
Excellent!! Glad it worked.
Posted on 8/24/17 at 7:56 am to Geaux-2-L-O-Miss
quote:
I've tried ATAN= and ATANH= as well as different format for the number in the cell and I'm not getting the right answer.
I believe excel wants the value in radians.
Popular
Back to top
Follow TigerDroppings for LSU Football News