1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

What do i need to do to make sin and cos work properly?

So im currently doing calculations for sprocket gear teeth design and im trving to make it easy for me to just change the number of teeth and get all the numbers i need for the design, im stuck however at my first sin, cos functions, im aware that excel uses radians, ive tried using both the radians function and pi/180 (both in the formula and as a cell input, but i am consistantly getting the same wrong answer, ive even switched my digital ti-83 plus to radians and inputed the numbers and i get the same answer.

Currently stuck on formulas for M and T, ive tried

=0.8*C2*COS(Radians(F2))

=0.8*C2*COS(T2*F2)

=0.8*C2*COS(Radians(35+(60/B2)))

B2=9

C2=0.4

F2=(35+(60/B2))=41.66666667

T2=U2/180

U2=Pi()=3.141592654

The answer i am consistantly getting is 0.239048023

In my digital ti-83 plus i switched to radians and input 0.8*0.4*cos(0.727220522)=.2390480227

I even checked google to make sure that F2 when converted to radians is correct and it is.

When i do the calculation in degrees it looks like this

0.8* 04*cos(35+(60/9))=0 2599753216

What do i need to do to get the answer im looking for

submitted by /u/TheMayo16
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#digital transformation in spreadsheet software
#Excel compatibility
#Excel alternatives
#rows.com
#AI formula generation techniques
#google sheets
#formula generator
#sprocket gear teeth design
#radians
#sin
#cos
#formulas
#excel
#calculations
#digital ti-83 plus
#C2
#B2