Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word 2000 formula field
I am attempting to complete a word document that would place an X in the
appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are€¦ if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
#2
|
|||
|
|||
Where is the 'overall rating' coming from?
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: I am attempting to complete a word document that would place an X in the appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are. if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
#3
|
|||
|
|||
"Overall rating" is the result from a number of formulas. Here is the
breakdown. This form is an eval form with several separate number designations (6 score values and then 6 weight values) . I totaled each of the score values and weight values and then created another formula that divides the total score value by the total weight value which is the "overall rating". I was hoping to then have formula that would take the "overall rating" and place an "X" only in the corresponding cell/table from the scale. The scale is: 1.00-1.49, 1.50-2.49, 2.50-3.49 and 3.50-4.00 So what do you think is there a formula that I can input to see if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank? Thank you very much for you help "Graham Mayor" wrote: Where is the 'overall rating' coming from? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: I am attempting to complete a word document that would place an X in the appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are. if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
#4
|
|||
|
|||
Hmmm. We are getting there - slowly
I take it this is an on-line form ie a locked form with form fields? That being the case your form fields will each assign their content to a bookmark. The plan is therefore to take the content of that bookmark and use it in a conditional field outside the form fields. Let's assume the data you wish to test is in the first field of the form. Set that field's property 'calculate on exit' check box. In the cell where you want the result to appear enter the following field construction (CTRL+F9 for each field boundary pair) { IF { Ref Text1 } 2.49 "{ IF { REF Text1 } 4 "X" }" } Lock the form and whenever the field contains the data within the stated parameters you'll get an X in place of the conditional field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: "Overall rating" is the result from a number of formulas. Here is the breakdown. This form is an eval form with several separate number designations (6 score values and then 6 weight values) . I totaled each of the score values and weight values and then created another formula that divides the total score value by the total weight value which is the "overall rating". I was hoping to then have formula that would take the "overall rating" and place an "X" only in the corresponding cell/table from the scale. The scale is: 1.00-1.49, 1.50-2.49, 2.50-3.49 and 3.50-4.00 So what do you think is there a formula that I can input to see if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank? Thank you very much for you help "Graham Mayor" wrote: Where is the 'overall rating' coming from? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: I am attempting to complete a word document that would place an X in the appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are. if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
#5
|
|||
|
|||
Fabulous, it works!!!
Thank you very much for your assistance. ____________________ "Graham Mayor" wrote: Hmmm. We are getting there - slowly I take it this is an on-line form ie a locked form with form fields? That being the case your form fields will each assign their content to a bookmark. The plan is therefore to take the content of that bookmark and use it in a conditional field outside the form fields. Let's assume the data you wish to test is in the first field of the form. Set that field's property 'calculate on exit' check box. In the cell where you want the result to appear enter the following field construction (CTRL+F9 for each field boundary pair) { IF { Ref Text1 } 2.49 "{ IF { REF Text1 } 4 "X" }" } Lock the form and whenever the field contains the data within the stated parameters you'll get an X in place of the conditional field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: "Overall rating" is the result from a number of formulas. Here is the breakdown. This form is an eval form with several separate number designations (6 score values and then 6 weight values) . I totaled each of the score values and weight values and then created another formula that divides the total score value by the total weight value which is the "overall rating". I was hoping to then have formula that would take the "overall rating" and place an "X" only in the corresponding cell/table from the scale. The scale is: 1.00-1.49, 1.50-2.49, 2.50-3.49 and 3.50-4.00 So what do you think is there a formula that I can input to see if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank? Thank you very much for you help "Graham Mayor" wrote: Where is the 'overall rating' coming from? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: I am attempting to complete a word document that would place an X in the appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are. if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
#6
|
|||
|
|||
Glad we got there in the end
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: Fabulous, it works!!! Thank you very much for your assistance. ____________________ "Graham Mayor" wrote: Hmmm. We are getting there - slowly I take it this is an on-line form ie a locked form with form fields? That being the case your form fields will each assign their content to a bookmark. The plan is therefore to take the content of that bookmark and use it in a conditional field outside the form fields. Let's assume the data you wish to test is in the first field of the form. Set that field's property 'calculate on exit' check box. In the cell where you want the result to appear enter the following field construction (CTRL+F9 for each field boundary pair) { IF { Ref Text1 } 2.49 "{ IF { REF Text1 } 4 "X" }" } Lock the form and whenever the field contains the data within the stated parameters you'll get an X in place of the conditional field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: "Overall rating" is the result from a number of formulas. Here is the breakdown. This form is an eval form with several separate number designations (6 score values and then 6 weight values) . I totaled each of the score values and weight values and then created another formula that divides the total score value by the total weight value which is the "overall rating". I was hoping to then have formula that would take the "overall rating" and place an "X" only in the corresponding cell/table from the scale. The scale is: 1.00-1.49, 1.50-2.49, 2.50-3.49 and 3.50-4.00 So what do you think is there a formula that I can input to see if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank? Thank you very much for you help "Graham Mayor" wrote: Where is the 'overall rating' coming from? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org gywnfryd wrote: I am attempting to complete a word document that would place an X in the appropriate cell of my table if it meets the formula requirements. The requirements that I want to have for this formula are. if the "overall rating" is = 2.50 and is also = 3.49 then it would populate the cell with an "X" if not then it would leave the cell blank. Is this possible? Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Word 2003 documents to WordPerfect formate | Microsoft Word Help | |||
how to convert wordperfect 5.0 floppy files to word | Microsoft Word Help | |||
Word 2000 Hyperlink Field Codes | New Users | |||
Basic macros query - where are they assigned to? | New Users | |||
Word Field Codes in Excel data file | Mailmerge |