If formula

Originally Posted by Janie
Hi,
I am trying to write a formula which states =if(N7="N",(o7/100)*15), ((o7/100))*20)
What I am looking for is: if N is in the column, divide column o by 100 * 15, otherwise divide by o *20.
Can someone help me out with this? The first half of the formula works, but when I add the other section I lose it.
Thanks,
Janie