IF field with a formula
- From: "Kima & Greg Schwend" <kimagreg@xxxxxxxxx>
- Date: Thu, 20 Aug 2009 18:49:14 -0700 (PDT)
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
.
- Follow-Ups:
- Re: IF field with a formula
- From: Doug Robbins - Word MVP
- Re: IF field with a formula
- Prev by Date: RE: Table columns out of alignment
- Next by Date: Re: IF field with a formula
- Previous by thread: How to link Tables
- Next by thread: Re: IF field with a formula
- Index(es):
Relevant Pages
|
