conditional calculations

[shanep]

I want to compare a numerical value (2 or4) and then execute a calculation
*.17 for 2 and .68 for 4. These are referenced from other fields in the same
form. Also I am getting a zero divide error in a seperate field unrelated.
This is understood and fine but I would like to keep the message suppressed
for blank form printing. I attempted to use "if blah=0 empty space as
true text (" " format ) and then a simple division for false.
I end up with syntax errors and my expression evaluated as text Help!!

Shane

 

[Greg Maxey]

It doesn't sound like your question is VBA related. I think you are asking
about Word fields.

Say you have a field bookmarked "No1" and this field can have the value 2 or
4. Try:

{ If { No1 } = "2"{ =({ No1 }*.17) }{ =({ No1 }*.64) } }

Say you have another field bookmarked No2. For the zero divide issue, try:

{ If { =({ No1}/{ No2}) } = "!Zero Divide"" "{ =({ No1}/{ No2 }) } }