Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Kay Kay is offline
external usenet poster
 
Posts: 33
Default If functions in table cells

I have read some of the post on calcualations in word tables and have dome
many over the years, but not as complicated as I have seen in the download
files. I have a word table that recieves its data as a bookmark from a form
in another section. If the bookmark returns 1 - Unsatisfactory, I want the
next column in the corresponding row to show 1 so that I can then total that
column and divide by the number of entries. I assumed...{if(B2="1 -
Unsatisfactory",1,"")}. I always get a syntax error. Inf act, I need to
nest five ifs. if(B2="1 - Unsatisfactory",1,if(B2="2 - Nees
Improvement",2,if(b2=3 - Meets Expcetations",3," ")}. etc...

Any help will be appreciated.
 
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
Resize Word table cells without moving/resizing the other cells? hoozieg Tables 2 October 4th 07 11:15 PM
Putting Table of Contents into Table Cells Josh Craig Tables 7 June 12th 07 03:21 AM
want cells in a table to copy data from cells in another table Conrad D. Farner Tables 2 September 27th 06 04:21 PM
Referencing cells in a table Candace Tables 1 June 23rd 05 06:52 PM
pb creating of the cells in a table neonico Tables 2 February 7th 05 12:29 AM


All times are GMT +1. The time now is 03:38 AM.

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"