View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
paul paul is offline
external usenet poster
 
Posts: 249
Default 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!