=if(statement, true, false)

[jbc]

Hi,

Does word have the if function like Excel?

Thanks.

jbc

 

[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.

 

[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.

 

[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.

 

[cst]

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