MSWord If Functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 10 Feb 2005 01:15 GMT

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

Reply to this Message

Greg Maxey - 10 Feb 2005 01:41 GMT

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.

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> 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
[quoted text clipped - 7 lines]
> Thanks
> Greg

Reply to this Message

Greg - 10 Feb 2005 21:50 GMT

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

>-----Original Message-----
>Greg,
[quoted text clipped - 20 lines]
>
>.

Reply to this Message