Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
KennyH KennyH is offline
external usenet poster
 
Posts: 1
Default Excel formula doesn't work in Word Table

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(D93,"Low",IF(D103,"Low",IF(D113,"Lo w",IF(D123,"Low",IF(D133,"Low","Medium"))))))="M edium",IF(D20=31,"High","Medium"),"Low")
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Excel formula doesn't work in Word Table

Hi Kenny,

With Word, the formula syntax for string testing is different from what you use in Excel. For more details, check out my Word Field
Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[MVP - Microsoft Word]


"KennyH" wrote in message ...
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(D93,"Low",IF(D103,"Low",IF(D113,"Lo w",IF(D123,"Low",IF(D133,"Low","Medium"))))))="M edium",IF(D20=31,"High","Medium"),"Low")


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need formula in excel spreadsheet to work in multple word pages philber Microsoft Word Help 8 September 18th 08 11:24 AM
Formula from Excel does not work with Word KLR Tables 2 March 31st 08 11:11 PM
Excel Formula to Word Table setoFairfax Tables 1 November 21st 07 04:11 AM
excel formula table into word Krohm Microsoft Word Help 1 April 26th 05 02:00 PM
How do I get a formula "=SUM(ABOVE)" to work in a protected WORD . Monica Microsoft Word Help 1 February 22nd 05 05:42 PM


All times are GMT +1. The time now is 09:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"