calculations

Does anyone know how to write a formula in a word table
that would do the following:

take the sum of two cells, divide them by the first,
multiply them by 100

=sum/a1(left)*100 doesn't work right
=sum(left)/a1,*100 doesn't work right

Thanks,
Rhonda

Bonjour,

Dans son message, Rhonda Crawford écrivait :
In this message, Rhonda Crawford wrote:

|| Does anyone know how to write a formula in a word table
|| that would do the following:
||
|| take the sum of two cells, divide them by the first,
|| multiply them by 100
||
|| =sum/a1(left)*100 doesn't work right
|| =sum(left)/a1,*100 doesn't work right
||

Use adresse references, as in:
{=((A1 + B1)/A1)*100 }
or select the cell content (without the end of cell marker) and assign a
bookmark to the selection. Use those in the formula, as in:
{=((CellOne + CellTwo)/CellOne)*100 }

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

OK, the below is what is entered and it still comes up=20
wrong.

=3D((a1+b1/a1)*100)

The way it is now, if you had 2 in a1 and 2 in b1 you'd be=20
doing this:

4/2*100 =3D 200%

The answer I am trying to get is: =3D 50%


-----Original Message-----
Bonjour,

Dans son message, Rhonda Crawford =E9crivait :
In this message, Rhonda Crawford wrote:

|| Does anyone know how to write a formula in a word table
|| that would do the following:
||
|| take the sum of two cells, divide them by the first,
|| multiply them by 100
||
|| =3Dsum/a1(left)*100 doesn't work right
|| =3Dsum(left)/a1,*100 doesn't work right
||

Use adresse references, as in:
{=3D((A1 + B1)/A1)*100 }
or select the cell content (without the end of cell=20
marker) and assign a
bookmark to the selection. Use those in the formula, as=20
in:
{=3D((CellOne + CellTwo)/CellOne)*100 }

--=20
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP

Word MVP site: http://www.word.mvps.org



.

Bonjour,

Dans son message, écrivait :
In this message, wrote:

| OK, the below is what is entered and it still comes up
| wrong.
|
| =((a1+b1/a1)*100)

I do not think we have a formula problem here...

Your parenthesis are confusing:
a1 = 2
b1 = 2
=((a1+b1/a1)*100)
=((2+2/2)*100)
=((2+1)*100)
=((3)*100)
=(300)

Try:
a1 = 2
b1 = 2
=((a1+b1)/a1)*100
=((2+2)/2)*100
=((4)/2)*100
=(2)*100
=200

| The way it is now, if you had 2 in a1 and 2 in b1 you'd be
| doing this:
|
| 4/2*100 = 200%
|
| The answer I am trying to get is: = 50%


It still did not yield 50% because this does exactly what you wrote you
wanted in your first post:
quote
take the sum of two cells, divide them by the first,
multiply them by 100
unquote

I got confused with your usage of "them"... I did not (and still do not!
:-) ) know what it referred to.
I guess what you want is:

a1 = 2
b1 = 2
=(a1/(a1+b1)*100
=(2/(2+2)*100
=(2/(4))*100
=(0.5)*100
=50
or
a1 = 8
b1 = 4
=(a1/(a1+b1)*100
=(8/(8+4)*100
=(8/(12))*100
=(0.66)*100
=66

Is that what you want?
(I.e. a percentage representation of the first number in relation to the
total?)
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Thank you very much for your help. The formula needed was:

=3Da1/(a1+b1)*100



-----Original Message-----
Bonjour,

Dans son message, =20
=E9crivait :
In this message, =20
wrote:

| OK, the below is what is entered and it still comes up
| wrong.
|
| =3D((a1+b1/a1)*100)

I do not think we have a formula problem here...

Your parenthesis are confusing:
a1 =3D 2
b1 =3D 2
=3D((a1+b1/a1)*100)
=3D((2+2/2)*100)
=3D((2+1)*100)
=3D((3)*100)
=3D(300)

Try:
a1 =3D 2
b1 =3D 2
=3D((a1+b1)/a1)*100
=3D((2+2)/2)*100
=3D((4)/2)*100
=3D(2)*100
=3D200

| The way it is now, if you had 2 in a1 and 2 in b1 you'd=20
be
| doing this:
|
| 4/2*100 =3D 200%
|
| The answer I am trying to get is: =3D 50%


It still did not yield 50% because this does exactly what=20
you wrote you
wanted in your first post:
quote
take the sum of two cells, divide them by the first,
multiply them by 100
unquote

I got confused with your usage of "them"... I did not=20
(and still do not!
:-) ) know what it referred to.
I guess what you want is:

a1 =3D 2
b1 =3D 2
=3D(a1/(a1+b1)*100
=3D(2/(2+2)*100
=3D(2/(4))*100
=3D(0.5)*100
=3D50
or
a1 =3D 8
b1 =3D 4
=3D(a1/(a1+b1)*100
=3D(8/(8+4)*100
=3D(8/(12))*100
=3D(0.66)*100
=3D66

Is that what you want?
(I.e. a percentage representation of the first number in=20
relation to the
total?)
--=20
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP

Word MVP site: http://www.word.mvps.org



.

Bonjour,

Dans son message, Rhonda Crawford écrivait :
In this message, Rhonda Crawford wrote:

| Thank you very much for your help. The formula needed was:
|
| =a1/(a1+b1)*100
|

Glad I could be of assistance.
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org