Sum and If Statements in Word Table

I am currently using a mail merged document (gathering information from
microsoft access).

I have a table that displays "yes" and "no" under various categories.
Basically, I would like for individuals in particular groups to have a charge
of $250.00 if they do not have a "no" for that particular category. Not every
category is a yes, so I would prefer to use the "not no" criteria.

The statement in excel looks like:
=SUM((IF((B2="Yes"),250,0)),(IF((B4"No"),250,0)) ,(IF((B5"No"),250,0)))

I get a syntax error with this formula.

This works in excel, but not in word's table l formula box.

I would appreciate your help!

Hi Paul,

Unfortunately, Word's cell referencing doesn't work for cells containing text; it's a numbers-only capability. For text, you need to
bookmark the cell contents (not the whole cell) and reference the bookmarks with the formulae.

For more info on field calculations in Word, check out my Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party

--
Cheers
macropod
[Microsoft MVP - Word]


"Paul" wrote in message ...
I am currently using a mail merged document (gathering information from
microsoft access).

I have a table that displays "yes" and "no" under various categories.
Basically, I would like for individuals in particular groups to have a charge
of $250.00 if they do not have a "no" for that particular category. Not every
category is a yes, so I would prefer to use the "not no" criteria.

The statement in excel looks like:
=SUM((IF((B2="Yes"),250,0)),(IF((B4"No"),250,0)) ,(IF((B5"No"),250,0)))

I get a syntax error with this formula.

This works in excel, but not in word's table l formula box.

I would appreciate your help!