Formulas in word 2007 cells

[Joachim]

I've found they answer to most off my problem by looking on the microsoft
word site ,its about the formulas in cell but i want to just use to cells to
the left instead of the hole row
(ex.PRODUCT(left)) could you please tell me what to fill in instead off left
to utilize just to cells on the left instead off them all i just need to
make a formula to multiply the 3rd with the 4rd tabel

Km per dag

(heen en terug)
X aantal dagen
Totaal km
X bedrag per km
Totaal
fietsvergoeding

42
1
PRODUCT(left)
€ 0.15
Formula in here

[Peter Jamieson]

Try { =PRODUCT(C:D) }

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

[Peter Jamieson]

Sorry, if you have more than one row then you need

{ =PRODUCT(Cn:Dn) }

or

{ =Cn*Dn }

where n is the row number in the table, e.g. for row 3 you need

{ =PRODUCT(C3:D3) }
or
{ =C3*D3 }

/Or/ if you insert an empty column before column C, you may be able to
use the following:
Column A 42
Column B 1
Column C empty
Column D { =PRODUCT(LEFT) }
Column E 0.15
Column F { =PRODUCT(LEFT) }

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

On 04/10/2009 16:32, Joachim wrote:

[Peter Jamieson]

(Sorry if this is a duplicate post)

> Try { =PRODUCT(C:D) }

For a multi-row table you will need the row number in there, e.g.

{ =PRODUCT(C2:D2) } for row 2, or { =C2*D2 }

But you could also try inserting an empty column after column B so you have

Column A: 42
Column B: 1
Column C: empty
Column D: { =PRODUCT(LEFT) }
Column E: 0.15

column F: { =PRODUCT(LEFT) }

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv