How do i set a table cell to autofill?


  1. Posts : 1
    Windows 10
       #1

    How do i set a table cell to autofill?


    Hi TenForums community, I currently have a task at hand and i'm not too sure how to solve it.
    How do i set a table cell to autofill?-screenshot_1.jpg

    I would like to automate the rightmost column on the RISK Ratings based on Likelihood and Impact.

    For example, under Risk 1, if i were to click "rare" as the likelihood and "insignificant" as the impact both from their own dropdown lists, i would like the risk rating to be automatically filled as "Low" with reference to the colourful table above.

    Another example would be if i chose Rare as Likelihood and Catastrophic as the Impact, i would automatically get back the risk rating of Medium on the rightmost column.

    Thank you so so much to whoever may have the answer to help me with this task.. <3

    Am using Windows 10, MS Word 2016.
      My Computer

  2. SoFine409's Avatar
    Posts : 1,294
    Win10 Pro
       #2

    Spelling + clarity


    Iíve never used Word to do this type of task, Iíve always used Exce,l so I donít know if formulas work the same but assuming they do, here is how I would try to do it. You could use a series of tests using the IF....ELSE function. Such as, IF this = number AND that = number THEN the number risk rating cell = whatever, ELSE add the next condition here using another IF/AND/THEN series until you reach the lowest rating and then the result falls through to the lowest risk rating. There is a lot of help on the web for Excel formulas and Excel will also check your expressions as you enter them. If you cannot get them to work post them here and we can help you.
    Last edited by SoFine409; 31 Mar 2020 at 18:55.
      My Computers

  3. retexan599's Avatar
    Posts : 77
    Windows 10 Home Version 20H2
       #3

    There is a very helpful forum for Microsoft Office. It can be found at Microsoft Office Forums - Word, Excel, Outlook, PowerPoint, Project. You will likely find excellent expertise there for your problem.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 02:33.
Find Us




Windows 10 Forums