Home |
Search |
Today's Posts |
#22
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
On Apr 8, 3:56*pm, "macropod" wrote:
Hi Cameron, As the error message said, you have a Syntax Error (ie you've coded the field wrongly). Try: {={unarmed_rate}+{IF{DropdownRow1}= "Armed" 10 0}} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Cameron.Crest" wrote in ... Graham, I've got a word form I'm trying to create and I am getting a syntax error in the main calcualation field. The form is for creating proposals/quotes of security services. I'm trying to get thecalculationto tell me what the cost will be for a client based on the contents of a dropdown form field. *All form fields are calculating on exit. Here's an outline: Form field: DropdownRow1 has 2 values: Armed, Unarmed (armed is chosen) Form field: Unarmed_Rate has a value of $21.00 Form field: qty1 has a value of 2 (thats 2 Officers) Here's thecalculationsyntax: { =IF{ DropdownRow1 }="Armed" "{ =unarmed_rate+10 }" "{ =unarmed_rate }"} Here's the error !Syntax Error, ARMED What am I doing wrong? - Hide quoted text - - Show quoted text - This worked like a charm. I cut and pase your formula and re-constructed it by highlighting each part with braces and pressing CTRL+F9 and removing the text braces. After protecting the doc for form entry, bingo. Updates when I change the dropdown and exit. Thanks a million. Cameron. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula in Word? | Microsoft Word Help | |||
Formula in Word | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
formula in word | Tables | |||
Word formula - HELP! | Tables |