If formula

[Janie]

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

[squiggler47]

too many brackets

=if(N7="N",(o7/100)*15,(o7/100)*20)

and those arnt necessary :
=if(N7="N",o7*15/100, o7*20/100)

[day92]

When you are creating a model you never want to hard code numbers as they might change and it makes it tremendous difficult to trouble shoot.

To that point I would put the numbers in a blank cell - lets say they are all in row 1. So the formula should read..

=if(N7="N",o7*a1/b1, o7*c1/b1)

[shg]

Looks like this is some kind of tax thing. Maybe

=IF(N7="N", 15%, 20%) * O7

As Day suggests, I'd put the 15% and 20% in cells, or named constants:

=IF(N7="N", taxrate1, taxrate2) * O7

[squiggler47]

Given the problems with the if formula you might be getting a little advanced for the OP!