Percentage Formula
in [General]
|
From: rosiesims on 11 May 2010 11:23 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% > > > > . >
From: Bob I on 11 May 2010 13:49
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% >>> >> >>. >> |