Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Now to program a sine divid by a sine function in Excel?

  1. Aug 28, 2011 #1
    This is part of the simulation program in Antenna field pattern. One part involve finding the position of the peak where:

    [tex]AF=\frac {\sin\;Nx}{sin \;x}\;\hbox { where N is an integer.}[/tex]

    The peak is at x=0 and the AF=N. But excel do not accept this and call out as "DIV 0" error. Is there any way to program it so when x= 0, it will show AF=N?

    THis is like sync function when x = 0. I don't know whether this is the right place to post, but this is the best I see fit.

  2. jcsd
  3. Aug 28, 2011 #2


    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    Hint: apply l'Hopital's Rule as x approaches 0. Then in Excel, test when x = 0 and use the appropriate expression for AF.
  4. Aug 28, 2011 #3


    User Avatar
    Science Advisor
    Homework Helper
    Gold Member

    I'm not sure of your context, but what about using the IF statement? For example, if you name one cell x and another cell N, something like this

    =if(sin(x) = 0, N, sin(N*x)/sin(x))
  5. Aug 28, 2011 #4
    I'll check the excel program.

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook