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

1. Aug 28, 2011

### yungman

This is part of the simulation program in Antenna field pattern. One part involve finding the position of the peak where:

$$AF=\frac {\sin\;Nx}{sin \;x}\;\hbox { where N is an integer.}$$

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.

Thanks

2. Aug 28, 2011

### SteamKing

Staff Emeritus
Hint: apply l'Hopital's Rule as x approaches 0. Then in Excel, test when x = 0 and use the appropriate expression for AF.

3. Aug 28, 2011

### LCKurtz

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

4. Aug 28, 2011

### yungman

I'll check the excel program.

Thanks