Why don't you highlight logical portions of the formula in
the formula bar and press the F9 key. That will give you
the values the formula is working with and should
help you determine what going on.
One issue, I can see is that "n2" should be N2.
If Excel was recognizing it as a cell reference, it would
be capitalized.

Jim Cone
San Francisco, USA


"Lisa H via OfficeKB.com" wrote in message
...
It kind of works the formulas I am entering look like this except the N2
values would change depending on what day it is (there are a total of 15
lines including "Formulas")
IF((n2/SUM(M15:M21)<1),n2/SUM(M15:M21),100%) - but when I click on one of
the formula options it gives me 200% or the next one gives me 300% as so on
down to 1500%. What am I doing wrong?!