=if(statement, true, false)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbc - 24 Oct 2003 00:14 GMT

Hi,

Does word have the if function like Excel?

Thanks.

jbc

Reply to this Message

Greg Maxey - 24 Oct 2003 00:39 GMT

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.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
Remove the obvious (wham...m) to reply in e-mail

> Hi,
>
[quoted text clipped - 3 lines]
>
> jbc

Reply to this Message

jbc - 24 Oct 2003 00:42 GMT

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.

>-----Original Message-----
>Hi,
[quoted text clipped - 5 lines]
>jbc
>.

Reply to this Message

Greg Maxey - 24 Oct 2003 01:03 GMT

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.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
Remove the obvious (wham...m) to reply in e-mail

> What is the syntax for it?
>
[quoted text clipped - 17 lines]
>> jbc
>> .

Reply to this Message

cst - 24 Oct 2003 13:51 GMT

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

Reply to this Message