Excel formula doesn't work in Word Table

K

KennyH

I need to test multiple calculations in table cells in order to determine the
grade(LOW/MEDIUM/HIGH) i.e. return in strings. The below formula works fine
in Excel. Any advice it can be put in use in Word table would be appreciate.
Please help!

=IF(IF(IF(D19<=16,"Low",IF(E19<=6,"Low",IF(SUM(E9:E13)<3,"Low",IF(SUM(E14:E18)<3,"Low","Medium"))))="Medium",IF(D9<3,"Low",IF(D10<3,"Low",IF(D11<3,"Low",IF(D12<3,"Low",IF(D13<3,"Low","Medium"))))))="Medium",IF(D20>=31,"High","Medium"),"Low")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top