MSWord If Functions

[Greg]

I have a table created in word. How can I write a formula
to populate a cell in this table only if the adjacent cell
meets specific criteria.

Ie, IF(A2>0,A1,0)

The above statement doesn't work and produces a syntax
error.

Thanks
Greg

 

[Greg Maxey]

Greg,

Are you try to write a formula field in a table cell or VBA to perfrom the
comparison.

You could use a formula field in Cell A1 to evaluate A2 e.g,

{ =If(A2>0,5,0) } with the meaning if A2 is greater than 0 then the value
of A1 is 5 Else A1 is 0. You don't need a macro.

 

[Greg]

Thanks. However, rather than the value 5 returned I'd like
to refer to a cell reference as the value will differ each
row.

Is this possible?

ie. instead of: =If(A2>0,5,0)
have: IF(A2>0,A1,0)

Thanks.
Greg