CODEWITHSUNDEEP
if-statementms-word
Tadas
Tadas

Reputation: 69

IF AND statement in MS WORD

I need a statement that gives a certain amount depending on the field value: If x is in the range between 10 and 20 then the answer is 15 if not then it should go to identical statement with a different range. I cant seem to get the first part working, this is what I got so far: {=IF(AND(x>10,x<20)"yes","no")}

Upvotes: 0

Views: 1319

Answers (2)

macropod
macropod

Reputation: 13505

You really don't need all that circumlocution. For example:

{IF«field»> 300 125 {IF«field»> 200 100 {IF«field»> 100 75 0}}}

Upvotes: 0

macropod
macropod

Reputation: 13505

Try:

{=INT((X-1)/10)=1 \# "'Yes';;'No'"}

Alternatively:

{=AND(Val>10,Val<20) \# "'Yes';;'No'"}

To see how to do a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at: https://www.msofficeforums.com/word/38720-microsoft-word-field-maths-tutorial.html or: http://www.gmayor.com/downloads.htm#Third_party

Upvotes: 1

Related Questions