## 4 Q & A posts tagged with sin

### How to convert to Excel formula?

Please help, im not sure about this Excel formula.

I need to enter the following equation into the formula/function bar in Microsoft Excel but not sure if its completely right .

V = 0.000045 + 1/4p0.09^2[0.15+0.035-(0.035cos180+v( 0.15^2-0.035^2sin^2*180))]

I think i got most of it right, but dont know how to do the Pi, Cos, Sin or the square root.

### Answer

Pi is PI() in excel

So od this

... 1/4*PI()*0.09^2 ...

### Please Help! How would i draw this graph on excel 2010?

http://imgur.com/IMLLE

Sorry the pic isn't rotated, and it's kinda small...

I can't figure out how to graph it:S I don't know how to insert negative x values in the graph, and i don't know how to change the default x values of 1,2,3,4, etc. to different numbers...

Please help! best answer will get 10 points today cause i'm in a ruuuush!

Thanks!

### Answer

This one looks like a SIN(x) graph for me

just do 1, 2, 3, 4, etc in col A, then do

=Sin(A1)

in column B

Then graph it

hope this is not too late

### How can I insert intervals of numbers, not discreet elements into Excel?

I need to sketch the sin, cos functions' graph in Excel. I have a problem with a domain. I don't want to manually type myriad values - even then, the graph is sharp, not curved, and inaccurate. Is there a possibility that I simply set an interval, infinite, but bounded set, as a domain? If yes, how do you do it?

### Answer

You need as many points as you can to do the exact curved sin

to answer your question, do the following:

- Do the first number you want in a cell, say you do 5 in cell E4

- Now do the second number with the intervals into the second say.

So if you want to have the numbers as 5, 15, 25 (with 10 interval), put 15 in cell E5

- Now select both cells

- Drag the selection from the black square at the right bottom corner down to whatever range you want.

Or, you can also do:

- Put 5 in cell E4

- Select some range of cells including cell E4 (Cells E4 to E20)

- Go to:

Edit > Series > Fill (if you have Excel2003 or earlier)

Home > Fill > Series (below SUM sign)

And select the interval and stop value

VBAXLMan

### How can i restore deleted excel files?

In my Server excel file missing then how can i restore that file

### Answer

I faced similar issue a while ago and restored all my deleted files

There is an application called FinalData, it worth every penny

Just make sure that you didn't create / copy large files into that drive that had your files

Check it out here

http://download.cnet.com/FinalData-Enterâ€¦

VBAXLMan