Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation in a table | Microsoft Word Help | |||
Conditional mail merge calculation not printing | Mailmerge | |||
MS Word table - problem with conditional formula | Tables | |||
Table calculation problem | Tables | |||
Calculation in table | Tables |