calculations

[Rhonda Crawford]

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
(e-mail address removed)

 

[Jean-Guy Marcil]

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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Guest]

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

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

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%

 

[Jean-Guy Marcil]

Bonjour,

Dans son message, < (e-mail address removed) > écrivait :

| 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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Rhonda Crawford]

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

=a1/(a1+b1)*100

 

[Jean-Guy Marcil]

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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org