=if(statement, true, false)

G

Greg Maxey

jbc,


Just like Excel I don't know, but there is an IF function in Word.

Type "IF Field" in Word Help and the Examples of IF Fields for a short
primer.
 
J

jbc

What is the syntax for it?

This is what I need it to do:

=If(intSmallEntityAmount=0,sum(xxxx),sum(jjjj))

That is how I would write it in Excel. Check the contents
of intSmallEntity, if it is 0 then sum(xxxx), if it is NOT
0 then sum(jjjj)

Thanks.
 
G

Greg Maxey

Jbc,

Word cell references are Apha columns and numberical rows. So if you had a
5 by 5 table you would have columns a through e and rows 1 through 5. Say
you have a numerical value in a1. If that number is 5 you want to add b1
through b5 and put the result in a2 otherwise add c1 through c5 and put the
resul in a2.

Here is the syntax

{ IF {=sum(a1)} = 5 "{ =sum(b1:b5)}""{=sum(c1:c5)}" where the { } are
field code brackets entered with CTRL+F9

You can adapt this to compare MergeField values as described in the Help
file.
 
C

cst

Yes it does - from Insert, Field, Mail Merge, If.
It's OK when you get your head around it!
CST
 
Top