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