Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
MS Word table - problem with conditional formula
Hi Peterkins,
A formula in Column C like: {IF B2=X {=2*2.9} \# £,0.00} should give the result you're after. However, this requires hard-coding both the entry fee and the number of entrants. If you set your table up so that Column C has the number of entries, and Column D has the fee per entry, you could use: {IF B2=X {=C2*D2} \# £,0.00} in Column E. For more on Word field maths, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 Cheers "Peterkins via OfficeKB.com" u20492@uwe wrote in message news:5e648d56f3b52@uwe... Hi Suzanne Thanks for your response. If one tries to construct the formula from the Word menu bar - Table Formula, the Formula dialogue appears and any formula constructed appears in the cell with a pair of braces around it. However if one pastes the IF function into the formula line it then appears as "=IF( )" (without the quotes of course). I have been unable to find any way to insert a pair of braces in the formula line. So I have constructed the formula directly in the table cell using Ctrl + F9 to insert the braces then keying in your suggested syntax. The formula was accepted into the cell without any error message, but when I selected the cell and updated it with F9 the cell remained blank even though there was an X in B3. Your alternative also performed similarly. It seems the inclusion of spaces does make a difference. In the following I have put asterisks where spaces occur: - {*IF*B2*=*"X"*{*=*PRODUCT(2.9,2),*}""*} This gives a "no result" i.e. the cell is blank when updated. {*IF*B2="X"*{*=*PRODUCT(2.9,2),*}""*} Removing the spaces either side of the first "=" causes a X to appear in the cell when it is updated. Unfortunately I am no further forward in finding what is wrong with the syntax of my version. Please may I ask you if you have actually tried to get this working on your system; I would be very interested to know. Suzanne S. Barnhill wrote: I think you're trying to use Excel syntax in Word. Word's syntax would be: { IF B3 = "X" { = PRODUCT (2.9,2) } "" } or just { IF B3 = "X" { = 2.9 * 2 } "" } -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...ables/200604/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WP merge file to Word | Tables | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Formula to Sum values in word table | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
Envelope Address | New Users |