Multiple conditions IF statement (how to write)

Anonymous
2018-07-09T22:07:12+00:00

Word 2013, using Legacy tools to create fill-in form

Using Word table with multiple rows and columns of differing sizes, merges, etc.

Cells 1-5 contain the legacy tool {form text}, Type = number, number format = 0, Bookmarks= Type, Returns, Volume, Deposits & Access; calculate on exit turned on in each cell

Cell 6 contains only formula =sum(above) and is bookmarked TOTAL; result is a number

Up to this point, it works great, giving me correct total each time I make changes to cells 1-5.

Now, I want to have another cell provide a text description which reflects the rating of the account based upon the TOTAL, which has 3 levels: Low, Medium, High.

in Excel, I would write:   =-if (A6 <=6, "Low", if (A6 >=10, "High", "Medium"))

This is how I entered in Word: 

{ IF (TOTAL <= “6” “LOW” IF (TOTAL >= “10” “HIGH” “MEDIUM)) } 

No matter what the number in A6, the formula gives me a result of LOW.  I've tried adding commas, adding (), searching this group for the answer, but still can't figure out what I'm missing or including that's messing it up.  I'm sure it so simple, but I don't see it yet.  Can you help?

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Doug Robbins - MVP - Office Apps and Services 323.8K Reputation points MVP Volunteer Moderator
2018-07-09T22:57:43+00:00

You need to use { REF Total } as in

Was this answer helpful?

2 people found this answer helpful.
0 comments No comments

7 additional answers

Sort by: Most helpful
  1. Paul Edstein 82,871 Reputation points Volunteer Moderator
    2018-07-11T00:54:14+00:00

    Try:

    {=Total # "{=INT(({=Total}-1)/3)-2 # "'High';'Low';'Medium'"};;"}

    Was this answer helpful?

    0 comments No comments
  2. Doug Robbins - MVP - Office Apps and Services 323.8K Reputation points MVP Volunteer Moderator
    2018-07-11T00:42:56+00:00

    Use the following:

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-07-11T00:19:56+00:00

    Hi Doug,

    After multiple attempts to translate what I think I see in your example into what I type, I finally managed to get it "just right" and it worked!  Also, part of my problem was trying to use the formula wizard to complete it and not getting the proper brackets.  Thank you so much!!! ☺

    Now I have one more problem to solve.  This form is meant to be used electronically by staff, but it could be printed and handwritten.  In my TOTAL formula, I have {=sum(above) # "##"} which doesn't show/print the 0 when nothing is input in above cells.  Works, but is there a better way?  

    However, the result of the rating formula you describe shows LOW when the form is not filled in.  How do I fix it so that it too is blank until TOTAL is > 0.

    0 = blank;   1-6 = LOW   7-9 = MEDIUM   10+ = HIGH

    (PS _ you need to add " after MEDIUM in your example).

    Was this answer helpful?

    0 comments No comments
  4. Paul Edstein 82,871 Reputation points Volunteer Moderator
    2018-07-09T23:40:06+00:00

    For the conditions described, you could use a field coded as:

    {=INT(({=Total}-1)/3)-2 # "'High';'Low';'Medium'"}

    Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

    Was this answer helpful?

    0 comments No comments