A family of Microsoft word processing software products for creating web, email, and print documents.
You need to use { REF Total } as in
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
A family of Microsoft word processing software products for creating web, email, and print documents.
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.
Try:
{=Total # "{=INT(({=Total}-1)/3)-2 # "'High';'Low';'Medium'"};;"}
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).
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.