Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
IF field with a formula
I have a table that contains form fields that are bookmarked. I want
to use an IF field to prevent a divide by zero error and to display the result of an equation. The fields are defined as number fields and bookmarked Text66, Text67, and Text68. The formula is =Text66/Text67*Text68 The formula works if I don't use the IF statement. But I want to display nothing if Text67 is blank or 0. { IF Text67 0 =Text66/Text67*Text68 \# "0.00" ""} This just displays =Text66/Text67*Text68 if Text67 is greater than 0. I've tried to use an extra set of brackets to contain the true result (by pressing ctrl+F9) but that doesn't work, nor does containing the true result with quotes. How can I display my true result as a number and not text? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word field formula | Mailmerge | |||
text in formula field | Microsoft Word Help | |||
Merge field delimiter in insert field formula ? | Mailmerge | |||
Date Formula in a Field | Microsoft Word Help | |||
field formula | Tables |