- 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
[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