Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Modern Farm & Ranch Modern Farm & Ranch is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default 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   Report Post  
Posted to microsoft.public.word.tables
Steven M (remove wax and invalid to reply) Steven M (remove wax and invalid to reply) is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.tables
Steven M (remove wax and invalid to reply) Steven M (remove wax and invalid to reply) is offline
external usenet poster
 
Posts: 5
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pre-set Query Conditions that cannot be changed Charity Event Secretary Mailmerge 4 April 17th 06 05:56 PM
Multiple conditions in merge Stephen Green Mailmerge 12 December 20th 05 07:38 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
what is the definition for socioeconomic conditions? gabby_04 Microsoft Word Help 2 October 6th 05 06:42 AM
Multiple Conditions in IF Fields Brendan Vassallo Microsoft Word Help 2 March 11th 05 01:57 AM


All times are GMT +1. The time now is 09:55 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"