Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
IF formula with multiple conditions
I want to accomplish this in Word using Field Code (CTL+F9) (A value is
entered into "Text1"): IF Text1=1500 then 225 IF Text1 1500 =2500 then 325 IF Text1 2500=3500 then 455 IF Text1 3500 then Text1*.13 I can't seem to figure out the correct syntax. Any help would be very much appreciated! |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
IF formula with multiple conditions
See the "Specify multiple conditions" section of the Word Help topic
"Examples of IF fields." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Modern Farm & Ranch" wrote in message ... I want to accomplish this in Word using Field Code (CTL+F9) (A value is entered into "Text1"): IF Text1=1500 then 225 IF Text1 1500 =2500 then 325 IF Text1 2500=3500 then 455 IF Text1 3500 then Text1*.13 I can't seem to figure out the correct syntax. Any help would be very much appreciated! |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
IF formula with multiple conditions
Je Thu, 19 Jul 2007 17:28:01 -0700, Modern Farm & Ranch
skribis: I want to accomplish this in Word using Field Code (CTL+F9) (A value is entered into "Text1"): IF Text1=1500 then 225 IF Text1 1500 =2500 then 325 IF Text1 2500=3500 then 455 IF Text1 3500 then Text1*.13 I can't seem to figure out the correct syntax. Any help would be very much appreciated! I'm not sure what you mean by "entered into". I'm assuming here that you have defined a bookmark somewhere else in the document, named Text1. Also the braces have to be created by Ctrl-F9, not by typing them. Here it is: { if { ref Text1 } 3500 { = Text1 * 1.13 } { if { ref Text1 } 2500 455 { if 1234 1500 325 225 } } } How it works might be clearer if I add program-style line breaks and indenting: { if { ref Text1 } 3500 { = Text1 * 1.13 } { if { ref Text1 } 2500 455 { if 1234 1500 325 225 } } } -- Steven M - lid (remove wax and invalid to reply) "It's a damned fool mind that can only think of one way to spell a word." -- attributed to Dizzy Dean |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
IF formula with multiple conditions
Je Thu, 19 Jul 2007 23:44:49 -0500, "Steven M (remove wax and invalid
to reply)" skribis: Je Thu, 19 Jul 2007 17:28:01 -0700, Modern Farm & Ranch skribis: I want to accomplish this in Word using Field Code (CTL+F9) (A value is entered into "Text1"): IF Text1=1500 then 225 IF Text1 1500 =2500 then 325 IF Text1 2500=3500 then 455 IF Text1 3500 then Text1*.13 I can't seem to figure out the correct syntax. Any help would be very much appreciated! I'm not sure what you mean by "entered into". I'm assuming here that you have defined a bookmark somewhere else in the document, named Text1. Also the braces have to be created by Ctrl-F9, not by typing them. Here it is: Sorry, a couple of bugs. This should work: { if { ref Text1 } 3500 { = { ref Text1 } * 1.13 } { if { ref Text1 } 2500 455 { if { ref Text1 } 1500 325 225 } } } How it works might be clearer if I add program-style line breaks and indenting: { if { ref Text1 } 3500 { = { ref Text1 } * 1.13 } { if { ref Text1 } 2500 455 { if { ref Text1 } 1500 325 225 } } } -- Steven M - lid (remove wax and invalid to reply) "It's a damned fool mind that can only think of one way to spell a word." -- attributed to Dizzy Dean |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pre-set Query Conditions that cannot be changed | Mailmerge | |||
Multiple conditions in merge | Mailmerge | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
what is the definition for socioeconomic conditions? | Microsoft Word Help | |||
Multiple Conditions in IF Fields | Microsoft Word Help |