Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Percentage formula in excel

16 views
Skip to first unread message

Fred Smith

unread,
Feb 14, 2008, 11:42:18 PM2/14/08
to
Yes, if you tell us what formula and data you have.

Regards,
Fred

"Trevea" <Tre...@discussions.microsoft.com> wrote in message
news:E9B544AC-F877-4191...@microsoft.com...
>I have 4 columns which I have set up with a formula to calculate
>percentage.
> The 4 column formulas should equal 100% but they equal 106%. Can you
> help?

Trevea

unread,
Feb 15, 2008, 1:04:00 AM2/15/08
to

"Trevea" wrote:

>
>
> "Trevea" wrote:


>
> >
> >
> > "Trevea" wrote:
> >
> > > I have 4 columns which I have set up with a formula to calculate percentage.
> > > The 4 column formulas should equal 100% but they equal 106%. Can you help?
> >

> > Sorry the last post had incorrect information

Column Totals
d38 52,301,407,62
e38 971,978.64
f38 4050.00
g38 734,810.51
h38 247,068.13

Formulas
e38/d38
f38/e38
g38/(e38-f38)
h38/(e38-f38)
f38/e38

Fred Smith

unread,
Feb 15, 2008, 8:50:50 AM2/15/08
to
Why do you expect the percentages to add to 100%? You're not dividing by the
sum of the numbers.

If you're want to calculate the percentage of the total, first make sure
you're dividing by the total.

Regards,
Fred.

"Trevea" <Tre...@discussions.microsoft.com> wrote in message

news:CE4F8D23-5A13-4571...@microsoft.com...

0 new messages