A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » About WordBanter » About this forum
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Formula in Word Table



 
 
Thread Tools Display Modes
  #1  
Old June 18th 13, 08:04 AM
MarcS MarcS is offline
Junior Member
 
First recorded activity by WordBanter: Jun 2013
Posts: 1
Post Formula in Word Table

I have a Word 2007 table that allows a user to enter a 1 character Text Form Field in a cell. The Text Form Field has been bookmarked with the name "Question1". The word document is protected to enable only "Filling in forms" type editting. They can enter either the letters A, B, C or D as a result of a multiple choice. In another cell, I want to create a formula that will return a number based on the letter the user entered. For example; A=1, B=2, C=3 and D=4. When the user tabs out of the Text Form Field the cell containing the formula is updated automatically.

Would appreciate any help with this
Ads
  #2  
Old November 24th 15, 04:22 AM
nananaja003 nananaja003 is offline
Junior Member
 
First recorded activity by WordBanter: Oct 2015
Posts: 3
Default

I've managed to resolve by using a nested if function with.
gclub royal
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in Word Table Stuart Mattinson Tables 4 May 12th 09 09:51 PM
Word Table Formula Jseakin Tables 1 April 23rd 09 08:48 PM
Can word do this formula =EXP(B2) in a table? GT Tables 1 August 8th 07 01:43 AM
how do I get this formula (A2*d2)-e2 in a word table Big dogs Tables 2 April 22nd 06 12:03 PM
How do I set up a formula in a table in Word? Kathleen Tables 2 November 1st 05 07:49 AM


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.