| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with If statements in a Word Table using Form fields | Microsoft Word Help | |||
| Using Formulas within IF statements in Word | Tables | |||
| IF Statements in Word Fields | Microsoft Word Help | |||
| If -Then-Else Statements in Word 2003 | Mailmerge | |||
| how to create cells in table using if statements in word | Mailmerge | |||
Threaded Mode