Percentage Formula

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello,

I have a column for Full Year Forecast (A1) and one for 04-
05 Suggested Goals (A/2). To find the percentage increase
I used the formula (A1/A2). If column A1 is 33 and A2 =
17. It shows 52%. I would like for it to show that the
goals for the new year is less than what is projected to
be sold. Am I doing this incorrectly? Is there a better
way to do this?

Thanks,
Chris
 
Chris,

It seems that you need more columns.

In A1 you have the goal for the whole year ( 33 in your example)
In A2 you have the goal for 04-05 ( =A1 / 2 ) ( =16.5 in your example)
In A3 you then have the realised value ( 17 ; input)
In A4 you can then calculate : = (A3 - A2) / A2 ( +3,03...% if you
format as percentage)

The last column is the excess from the realised value (17) above the goal
(16,5).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Since you are looking for the increase between the years,
identify the change.

wihout the quotes in cell A3 "=(+A2-A1)/A1"
(format as percentage)

This will show you the percentage change compared to the
previous year.
 
Hello Team,

I am a bit confused...I used 209 in A1 (FY Proj) and 141
in A2 (NY Goals), when using Ozzie's first formula on a
couple of the items, I got a -68% when I used JE's formula
I got -32%. Could anyone explain.

Thanks for all of your help.
 
Chris,
Before actually going deeper into this can you explain a bit further what
exactly is in your cell.

I understood that you had a full years goal ( 33 in your first example) , a
"midyears" goal (half the full years goal, on 04-05 in the same example)
and a realised value of 17. If that is not the case what are those values
then ?

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top