Excel Sin graph of excell

L

littlewombat

Joined
May 9, 2011
Messages
1
Reaction score
0
[FONT=新細明體]A = [/FONT][FONT=新細明體]0.088[/FONT]
[FONT=新細明體]B = [/FONT][FONT=新細明體]3141.593[/FONT]
[FONT=新細明體]C = [/FONT][FONT=新細明體]0.005[/FONT]
[FONT=新細明體]D = [/FONT][FONT=新細明體]0.02[/FONT][FONT=新細明體] [/FONT]
[FONT=新細明體][/FONT]
[FONT=新細明體]x y[/FONT]
0 0
0.001


I want the cell in column y, which is next to the value 0.001 in the x column to

=$B$1*sin[$B$2*(A7+$B$3)]+$B$4

I have tried to create a sin graph using the values A,B,C,D and X . I can up with the fuction above, but it seems that i have made a mistake, how can i fix it:cry:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
Excel Excel 2003 Trend Equation Error 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Excel get a calculated value to land on a specific date 0
Excel Excel: Sort a column with #.#.# number and keep other column 0
Mandatory cells only if another cell is filled 0
Excel Concatenate with line breaks but ignore blank cells 3
curve fitting to a sine function 2

Top