The comparison you are making seems a bit confusing? You should be
saying that the target is reduce BY 24% not TO 24% of 150. So the Target
is actually 76% of 150 or 114. 100%-76%=24%. So for your monthly percent
would be the 100%-"the number"/150=your percentage.

rosiesims wrote:

well the months will be figures that i will get not figures i will create...

just want to create a formula that shows how each months figures are in
comparision to our target.

am i at 21% of my 24% target etc...

can't seem to get anything to work

"Bob I" wrote:


Depends, one way would be to have each cell drop by 2% so A1=150,
B1=A1*.98, C1=A1*.96.......

rosiesims wrote:


So here is the situation

Currently at 150 and over the next year we want decrease to 24% of that
So end result to be 114

How do I show each month as a percentage of that 24%?

Meaning if one month we are at 123, how do I show that in comparison to the
year end of 24%


.