Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
I have a small table with 4 or 5 fields that calculate based on the first
fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Thomas wrote:
I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Jay:
Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
You're welcome.
By the way, it occurred to me as I reread my reply that there's a simpler formula you could use: {=MAX( {=H9*15%}, 1500)} This one only calculates the 15% once, and then uses the larger of that number or 1500. Thomas wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Hi Thomas,
A simpler way to code the field is: {=IF(H9*0.151500,H9*0.15,1500)} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Thomas" wrote in message ... I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
I have a similar question. I have a calculated field that requires the
calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
First, each occurrence of the name of any of the dropdowns must be
surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Jay,
Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#9
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Sorry, it works for me, after converting the braces to field markers. Also
(as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#10
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Hi Jay,
I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#11
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word.
To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#12
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Hi Jay,
This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#13
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Something tells me -- not that you've actually said as much -- that you're
trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#14
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Hi Jay,
Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#15
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Jay,
OK, I did this in regular text and it worked. The result was that I got the numerical values in the text area. But what I want is to actually see the result of the entire formula in a text area. The formula in the text field looks like this: ={IF Y = Y { = ((3*25)+(0*20)+( 1*15)+(2*20)+(1*5)+100)} {=((3*25)+(0*20)+(1*15)+(2*20)+(1*5))}} The end result of what I want is to see the resultant value of the entire formula???? "Dots" wrote: Hi Jay, Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#16
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
When you lock the form, if you have entered it correctly the field
construction should 'disappear'. It should produce the result of the calculation when the fields that contribute to it are completed, you have the calculate on exit check box property of Dropdown6 checked and you tab out of that field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Dots wrote: Jay, OK, I did this in regular text and it worked. The result was that I got the numerical values in the text area. But what I want is to actually see the result of the entire formula in a text area. The formula in the text field looks like this: ={IF Y = Y { = ((3*25)+(0*20)+( 1*15)+(2*20)+(1*5)+100)} {=((3*25)+(0*20)+(1*15)+(2*20)+(1*5))}} The end result of what I want is to see the resultant value of the entire formula???? "Dots" wrote: Hi Jay, Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#17
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Graham,
I have the formula entered as follows: { IF N = Y =((3*25)+(0*20)+(1*15)+(2*20)+(1*5)+100) ((3*25)+(0*20)+(1*15)+(2*20)+(1*5))} Where N is the result of a field entry, as are the first numbers in each math expression. This is that I get when I lock the form and exit from the last field contributing to the expression. No matter what I do to change this syntax, the results are the same. What am I doing wrong? I've been trying this for 2 days now and can't seem to get it right???? "Graham Mayor" wrote: When you lock the form, if you have entered it correctly the field construction should 'disappear'. It should produce the result of the calculation when the fields that contribute to it are completed, you have the calculate on exit check box property of Dropdown6 checked and you tab out of that field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Dots wrote: Jay, OK, I did this in regular text and it worked. The result was that I got the numerical values in the text area. But what I want is to actually see the result of the entire formula in a text area. The formula in the text field looks like this: ={IF Y = Y { = ((3*25)+(0*20)+( 1*15)+(2*20)+(1*5)+100)} {=((3*25)+(0*20)+(1*15)+(2*20)+(1*5))}} The end result of what I want is to see the resultant value of the entire formula???? "Dots" wrote: Hi Jay, Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#18
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
Hi Dots,
I suggest you delete the formfield in which you're trying to do the calculation, and use an ordinary formula field instead. You could use the following field coding: {=Dropdown1*25+Dropdown2*20+Dropdown3*15+Dropdown4 *20+Dropdown5*5+{IF{Dropdown6}= Y 100 0}} where the field braces (there's only three pairs) are created via Ctrl-F9. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Dots" wrote in message ... Graham, I have the formula entered as follows: { IF N = Y =((3*25)+(0*20)+(1*15)+(2*20)+(1*5)+100) ((3*25)+(0*20)+(1*15)+(2*20)+(1*5))} Where N is the result of a field entry, as are the first numbers in each math expression. This is that I get when I lock the form and exit from the last field contributing to the expression. No matter what I do to change this syntax, the results are the same. What am I doing wrong? I've been trying this for 2 days now and can't seem to get it right???? "Graham Mayor" wrote: When you lock the form, if you have entered it correctly the field construction should 'disappear'. It should produce the result of the calculation when the fields that contribute to it are completed, you have the calculate on exit check box property of Dropdown6 checked and you tab out of that field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Dots wrote: Jay, OK, I did this in regular text and it worked. The result was that I got the numerical values in the text area. But what I want is to actually see the result of the entire formula in a text area. The formula in the text field looks like this: ={IF Y = Y { = ((3*25)+(0*20)+( 1*15)+(2*20)+(1*5)+100)} {=((3*25)+(0*20)+(1*15)+(2*20)+(1*5))}} The end result of what I want is to see the resultant value of the entire formula???? "Dots" wrote: Hi Jay, Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#19
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
You don't have enough fields in your construction. The Dropdown references
are REF fields and should be presented as {Dropdown1} or {REF Dropdown1} The correct syntax from the original message should be { IF{ Dropdown6 } = "Y" "{ =({ Dropdown1 } * 25) + ({ Dropdown2 } * 20) + ({ Dropdown3 } * 15) + ({ Dropdown4 } * 20) + ({ Dropdown5 } * 5) + 100 }" "0" } which will give a calculation result or 0 depending on whether Dropdown1 contains Y or not The sequence you present in this message should look like { IF N = "Y" "{ =((3*25)+(0*20)+(1*15)+(2*20)+(1*5)+100) }" "{ =(3*25)+(0*20)+(1*15)+(2*20)+(1*5) }" } and will result in 135 or 235 depending on the value of N The correct syntax for that would be: { IF{ Dropdown6 } = "Y" "{ =({ Dropdown1 } * 25) + ({ Dropdown2 } * 20) + ({ Dropdown3 } * 15) + ({ Dropdown4 } * 20) + ({ Dropdown5 } * 5) + 100 }" "{ =({ Dropdown1 } * 25) + ({ Dropdown2 } * 20) + ({ Dropdown3 } * 15) + ({ Dropdown4 } * 20) + ({ Dropdown5 } * 5)}" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Dots wrote: Graham, I have the formula entered as follows: { IF N = Y =((3*25)+(0*20)+(1*15)+(2*20)+(1*5)+100) ((3*25)+(0*20)+(1*15)+(2*20)+(1*5))} Where N is the result of a field entry, as are the first numbers in each math expression. This is that I get when I lock the form and exit from the last field contributing to the expression. No matter what I do to change this syntax, the results are the same. What am I doing wrong? I've been trying this for 2 days now and can't seem to get it right???? "Graham Mayor" wrote: When you lock the form, if you have entered it correctly the field construction should 'disappear'. It should produce the result of the calculation when the fields that contribute to it are completed, you have the calculate on exit check box property of Dropdown6 checked and you tab out of that field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Dots wrote: Jay, OK, I did this in regular text and it worked. The result was that I got the numerical values in the text area. But what I want is to actually see the result of the entire formula in a text area. The formula in the text field looks like this: ={IF Y = Y { = ((3*25)+(0*20)+( 1*15)+(2*20)+(1*5)+100)} {=((3*25)+(0*20)+(1*15)+(2*20)+(1*5))}} The end result of what I want is to see the resultant value of the entire formula???? "Dots" wrote: Hi Jay, Yes, I have a text form field set up. Now if I need to set in regular text, I must admit that I do not know how to do this. Can you advise on how I would do this? Thanks! "Jay Freedman" wrote: Something tells me -- not that you've actually said as much -- that you're trying to set up the formula inside a text form field. That will never work. The formula field has to be in regular text. Dots wrote: Hi Jay, This is very strange. I took the steps you indicate and Ctrl+F9 did show, but I assigned it anyway. Then tried a form text box, calculation and again nothing appeared when I pressed Ctrl+F9. I'm at a loss! "Jay Freedman" wrote: I suppose it's possible that Ctrl+F9 has become unassigned on your copy of Word. To check it: Go to Tools Customize and click the Keyboard button. Select the category "All Commands", and then select the command InsertFieldChars. The Current Keys box should show Ctrl+F9. If it doesn't, then click in the "Press new shortcut key" box and press Ctrl+F9, and click the Assign button. On Tue, 25 Mar 2008 13:47:02 -0700, Dots wrote: Hi Jay, I am using 2002. Funny thing is when I do the Ctrl+F9 to get the field markers, nothing happens.... I'll keep trying. Thanks for your help! "Jay Freedman" wrote: Sorry, it works for me, after converting the braces to field markers. Also (as expected) it works the same in Word 2003 and 2007, and I have no reason to expect different behavior in older versions. What are the contents of the entries in Dropdown6? Are they literally N and Y? And are the entries in the first 5 dropdowns all numbers? And, in the same sense as the help desk question "Is it plugged in?", have you checked to be sure forms protection is turned on? Dots wrote: Jay, Here is the exact syntax I am using. Only Dropdown6 is set to recalc on exit. The Calculated field still does not show the result of the calculation. Can you check my syntax to see if I am missing any special characters? In my review it appears to be set correctly? I'd appreciate a 3rd eye. {IF {Dropdown6} = Y {= (({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*15 )+({Dropdown4}*20)+({Dropdown5}*5)+100)} { =(({Dropdown1}*25)+({Dropdown2}*20)+({Dropdown3}*1 5)+({Dropdown4}*20)+({Dropdown5}*5))}} "Jay Freedman" wrote: First, each occurrence of the name of any of the dropdowns must be surrounded by field markers. This is easy to fix: Double-click an occurrence to select it, and press Ctrl+F9 to put the markers around it. Repeat for each of the others. (If they don't have field markers, they're just valueless text as far as the calculation is concerned.) Second, the 0 and extra closing marker at the end of your formula don't belong there. The general syntax of an IF field is IF (condition) (value if true) (value if false) In your formula, the condition is {Dropdown6} = "Y" and the two "equals" fields are the true and false values, respectively; there's no place in the syntax for that trailing 0. Third, make sure that the "Calculate on exit" option is checked in the Properties dialog of at least Dropdown6, and preferably for all six dropdowns. If only Dropdown6 has that, then the formula will be recalculated only when you exit that form field. If all of them have it, the formula will be recalculated each time you leave any of the fields. A final note: it's a really good idea to change the names of the form fields (in the Bookmark box of the Properties dialog) to descriptive terms. Then change the names in the calculated field to the same set of descriptive terms. It will make the calculations much easier to understand, especially if you have to edit them sometime later when you've forgotten how you put them together. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Dots wrote: I have a similar question. I have a calculated field that requires the calculation from previous dropdown boxes. My formula, based on this previous thread would look like this: {IF {Dropdown6} = "Y" {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5)+100)} {=((Dropdown1*25)+(Dropdown2*20)+(Dropdown3*15)+(D ropdown4*20)+(Dropdown5*5))} 0}} When I re-lock my form, I do not get any calculation in my form field. What am I doing wrong??? Thanks. "Thomas" wrote: Jay: Thank you so much, this is exactly what I was looking for. It works great! I was on your site today looking for this, but was not able to figure it out. Thank you very much. "Jay Freedman" wrote: Thomas wrote: I have a small table with 4 or 5 fields that calculate based on the first fields value. However, I need one field to calculate based on an IF function. I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500) but how do I write something like this in Word? I need to write a formula that can calculate 15% of the value in cell D1. If it is greater that 1,500, place the calculated value in this field, if it is not greater than 1,500, place 1,500 in this field. Please Help Using Ctrl+F9 to insert each matched pair of field braces, use this syntax: {IF {=(H9*15%)} 1500 {=(H9*15%)} 1500} -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#20
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
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 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 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 the calculation syntax: { =IF{ DropdownRow1 }="Armed" "{ =unarmed_rate+10 }" "{ =unarmed_rate }"} Here's the error !Syntax Error, ARMED What am I doing wrong? |
#21
Posted to microsoft.public.word.tables
|
|||
|
|||
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. |
#22
Posted to microsoft.public.word.tables
|
|||
|
|||
Word Formula using IF
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 message ... 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 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 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 the calculation syntax: { =IF{ DropdownRow1 }="Armed" "{ =unarmed_rate+10 }" "{ =unarmed_rate }"} Here's the error !Syntax Error, ARMED What am I doing wrong? |
#23
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. |
Reply |
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 |