entering in formula correctly...

Okay, the formula that I am working from is:

(RL+S) – sqrt [ RL^2 – (S*sin CA)^2 ] – S*cos CA

RL = 5.090
S = 1.5
CA = 107.5

With numbers plugged in:

(5.090+1.5) - sqrt [5.090^2 - (1.5*sin (107.5))^2] - 1.5*cos (107.5)

The final answer should be 2.156.

How can I put this into an Excel spreadsheet so I can just change out the 3 inputs and get the correct answers for each?

I am using Excel 2007.

Thanks for any help!

Here is the equation. For Excel COS & SIN functions are in Radians and need to be multiplied by Pi over 180 to convert to degrees.

Please Login or Register  to view this content.

Where your 3 values are located in cells A1, A2 and A3

ChemistB

Thank you very much!

Need some more help with something a little more complicated.

Okay I got another one that I need help with. Maybe someone can help explain it to me.

Formula on paper looks like:

(Pi*d^2/4) * 1-((cos(Open Angle + Closed Angle)) / (cos(Closed Angle)))

I am using this for a throttle body throat area formula.

D = Minimum Diameter and I am using 2 for now.
Open Angle = 75 degrees
Closed Angle = 15 degrees

They both equal 90 degrees.

I put it in Excel like this:

=((3.14*(B1)^2)/4)*(1-(COS(D1+C1))/(COS(C1)))

The answer was 1.29.

Did I do any of this correctly? Do I need to insert "RADIANS" anywhere?

Thanks again...

You'll still need to convert your trig functions to radians. Whereas the last time I suggested you multiply by pi and divide by 180, Excel does have the RADIANS function which converts degrees to radians, so easier to do it that way. So the formula looks like

Please Login or Register  to view this content.

ChemistB