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

Similar Threads

Can Excel do this? and if so which formula should I use 4
Excel 2003 : conditional format for 5 format settings 1
VLOOKUP isn't working properly in Excel on Mac 1
Estimates with multiple look ups 1
in a single worksheet,hw to match values based on 2 list 2
Formula for Multiple Variables. 1
Not sure whether to use VLOOKUP or an IF statement 2
Payment calculation 1

Top