View Single Post
  #21  
Old April 8th, 2008, 11:38 PM posted to microsoft.public.word.tables
Cameron.Crest
external usenet poster
 
Posts: 3
Default Word Formula using IF

On Apr 8, 3:28*pm, "Cameron.Crest" wrote:
Graham,

I've got awordform 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 the calculation to 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 2values: 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 the calculation syntax:
{ =IF{ DropdownRow1 }="Armed" "{ =unarmed_rate+10 }"
"{ =unarmed_rate }"}

Here's the error
!Syntax Error, ARMED

What am I doing wrong?


PS: Ignore the qty1 field.