If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#20
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|