Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Tom Stanley Tom Stanley is offline
external usenet poster
 
Posts: 2
Default Problem with conditional calculation in a table

I have an invoice that I want to create a conditional expression to display nothing on a zero result. The result is displayed in a Text Form Field (Type = Calculation, Maximum Length = Unlimited, Number Format = nothing, Bookmark = Text2, Calculate on Exit is Checked) Expression is as follows { IF {Quantity_1} 0 { = {Quantity_1} * {Price_1} \# $#,##0.00; } "" }

My problem is that when I protect the document and enter in info for Quantity_1 and Price_1 the result will not calculate and display. Both Quantity_1 and Price_1 are Number type Form Fields with Default numbers of 0. This one is driving me nuts and it's probably just a simple syntax error, but I can't seem to find the solution.........

EggHeadCafe - Software Developer Portal of Choice
Build A C# DNS MX Mail Record Query Class
http://www.eggheadcafe.com/tutorials...x-mail-re.aspx
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Problem with conditional calculation in a table

I may be off the mark, but I don't think you need to have this field in a
text form field. What you do need for IF fields in a protected form,
however, is to use REF fields for your bookmarks:

{ IF { REF Quantity_1 } 0 { = { REF Quantity_1 } * { REF Price_1 } \#
$#,##0.00; } }

You can omit the final "" since the FalseText is never required when it is
to be blank.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

Tom Stanley wrote in message ...
I have an invoice that I want to create a conditional expression to display
nothing on a zero result. The result is displayed in a Text Form Field
(Type = Calculation, Maximum Length = Unlimited, Number Format = nothing,
Bookmark = Text2, Calculate on Exit is Checked) Expression is as follows
{ IF {Quantity_1} 0 { = {Quantity_1} * {Price_1} \# $#,##0.00; } "" }

My problem is that when I protect the document and enter in info for
Quantity_1 and Price_1 the result will not calculate and display. Both
Quantity_1 and Price_1 are Number type Form Fields with Default numbers of
0. This one is driving me nuts and it's probably just a simple syntax
error, but I can't seem to find the solution.........

EggHeadCafe - Software Developer Portal of Choice
Build A C# DNS MX Mail Record Query Class
http://www.eggheadcafe.com/tutorials...x-mail-re.aspx


  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Problem with conditional calculation in a table

Hi Tom,

Instead of a calculation formfield, you could use a formula field coded as:
{=Quantity_1*Price_1 \# "$,0.00;;"}

--
Cheers
macropod
[Microsoft MVP - Word]


"Tom Stanley" wrote in message ...
I have an invoice that I want to create a conditional expression to display nothing on a zero result. The result is displayed in a
Text Form Field (Type = Calculation, Maximum Length = Unlimited, Number Format = nothing, Bookmark = Text2, Calculate on Exit is
Checked) Expression is as follows { IF {Quantity_1} 0 { = {Quantity_1} * {Price_1} \# $#,##0.00; } "" }

My problem is that when I protect the document and enter in info for Quantity_1 and Price_1 the result will not calculate and
display. Both Quantity_1 and Price_1 are Number type Form Fields with Default numbers of 0. This one is driving me nuts and it's
probably just a simple syntax error, but I can't seem to find the solution.........

EggHeadCafe - Software Developer Portal of Choice
Build A C# DNS MX Mail Record Query Class
http://www.eggheadcafe.com/tutorials...x-mail-re.aspx


  #4   Report Post  
Posted to microsoft.public.word.tables
Tom Stanley Tom Stanley is offline
external usenet poster
 
Posts: 2
Default Thanks!

Both Solutions worked.......Too bad the Word help documentation doesn't cover this subject a little better

Thanks Again,

Tom Stanley



macropod wrote:

Problem with conditional calculation in a table
02-Oct-09

Hi Tom,

Instead of a calculation formfield, you could use a formula field coded as:
{=Quantity_1*Price_1 \# "$,0.00;;"}

--
Cheers
macropod
[Microsoft MVP - Word]


"Tom Stanley" wrote in message ...

EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks #17
http://www.eggheadcafe.com/tutorials...-cool-net.aspx
Reply
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
Calculation in a table tphillips Microsoft Word Help 0 December 20th 07 11:07 PM
Conditional mail merge calculation not printing Stevieb19 Mailmerge 3 October 9th 06 04:39 AM
MS Word table - problem with conditional formula Peterkins Tables 20 April 18th 06 12:18 PM
Table calculation problem bob engler Tables 1 December 18th 05 08:10 AM
Calculation in table Ray Tables 3 July 22nd 05 07:12 PM


All times are GMT +1. The time now is 03:41 PM.

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

About Us

"It's about Microsoft Word"