How do I get this formula working in word? =LOOKUP

Hi all

I can't get this working in word... works fine in excel. If you can imagine the data across, obviously... any thoughts. Is there a better place to post this?

Lessons attended
17 (e.g.)
out of
21 (e.g.)
%
=SUM(a2/b2)
which is?
=LOOKUP(c2,{0,0.7,0.8,0.95},{"Unsatisfactory","Satisfactory","Good","Excellent"})


John
Answer
Answer
Do you mean that you inserted an Excel table in a Word table?
---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 30, 2022 Views 2,377 Applies to: