calculations in tables

[LM]

I am doing calculations in tables in Word but am having trouble with part of
the calculation. In cell A4, I want to insert multiple IF tests. I want to
say that if cell A3=10, make the number in cell A4=1, if cell A3=12, make the
number in cell A4=3, if cell A3=14, make the number in cell A4=5, etc., etc.
Cell A3 could calculate to any of five numbers and basically if it calculates
to a double number, I want it to add the two numbers together and put a
single number in cell A4. If, however, cell A3 is only a single number, I
just want that single number copied to cell A4.

Can someone please tell me how to do this. I have limited knowledge of
calculations in Word and am just learning as I go along. So far I have
managed but this one has got me beaten.

Thanks in anticipation of any replies.

 

[Graham Mayor]

The following placed in cell A4 will probably do the trick

{ IF { =A3 } > 9 "{ ={ =ROUND(A3,-1) } /10 + (A3 - { =ROUND(A3,-1) }) }"
"{ =A3 }" }

Note that the curly brackets are places with CTRL+F9 (each pair)
Note also that such fields will not automatically update. You must force an
update when the content of cell A3 changes. the simplest method is to attach
an update macro to a toolbar - http://www.gmayor.com/installing_macro.htm
Note A3 in the calculation is a table cell location and not a REF field.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

but note that

 

[LM]

In cell A3, I am calculating the number 2 by the value in cell A2. The value
in cell A2 can only be 0 to 9 (a single digit number). If the total that
ends up in cell A3 is two numbers, I want it to add those two numbers
together and put them in cell A4. If the total that ends up in A3 is a
single number, I want that single number in cell A4.

Your calculation worked perfectly until I got up to the numbers 8 and 9 in
cell A2 (which total 16 and 18 in cell A3 and should put 7 or 8 in cell A4).

Nearly there!!

 

[Graham Mayor]

Plan B

{ IF{ =A3 } > 9 "{ =({ =INT({ =(A3)/10 }) } + {=(A3) \# "x"})}" "{ =A3 }" }


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[LM]

Thank you for the quick response. I am going to try that now and will let
you know how I go.

I have another calculation I don't know how to do.

If I have the following in an Excel document:

=IF(A3=0,0,10-A3)

how would I do the same thing in a table cell in a Word document.

I have been given an Excel document containing heaps of calculations and
have been asked to do the same calculations in a Word document - I am almost
up to the final step.

Lyn.

 

[LM]

Thank you so much Graham. That worked beautifully. I never would have been
able to do that by myself.

Apart from the extra calculation I need to do listed below, the only other
thing I would like to be able to do is CONCATENATE. I can't find anywhere in
the help file that this is available in Word. If it is possible to
concatenate, can you please let me know how. If it isn't possible, this -
=IF(A3=0,0,10-A3) - as listed below - is the final thing I need to do to
finish my calculation.

 

[Graham Mayor]

The other calculation would be

{ IF {=A3 } = 0 "0" "{ =(10 - { =A3 } )}" }

Again calculations will not auto-update as they do in Excel
The Concatenate function if not available in Word. Whether there is a
workaround will depend on what you are trying to do. Frankly if complex
calculations are involved, it is usually simpler to insert the relevant
Excel table.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[LM]

Thank you so much for your help. I can get around not being able to
concatenate and I know you have to autoupdate. I can't believe I have
finally finished - I never could have done it without your help.

 

[Graham Mayor]

You are welcome