If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculations
|
#2
|
|||
|
|||
calculations
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 |
#3
|
|||
|
|||
calculations
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 . |
#5
|
|||
|
|||
calculations
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 . |
#6
|
|||
|
|||
calculations
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 |
Thread Tools | |
Display Modes | |
|
|