Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Kima & Greg Schwend Kima & Greg Schwend is offline
external usenet poster
 
Posts: 6
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
word field formula dave Mailmerge 1 August 9th 07 06:26 PM
text in formula field Miranda Microsoft Word Help 5 February 13th 06 09:15 AM
Merge field delimiter in insert field formula ? AlexT Mailmerge 3 November 24th 05 12:25 PM
Date Formula in a Field Thomas M Microsoft Word Help 4 April 25th 05 03:58 PM
field formula Jessica Tables 1 December 2nd 04 11:46 PM


All times are GMT +1. The time now is 06:40 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"