Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I enter an if,then,else formula with an embedded sum formul
I want to create a formula in a word table like the following but everything
I have tried, I get a syntax error. Can anyone tell me the correct format for this formula? if (or(c30,d30),sum(e2,c3,d3),"") It's not that complex but I can't get the exact formating down so that it will work. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I enter an if,then,else formula with an embedded sum formul
Your main problem is that Word doesn't have OR or SUM functions. Word tables
are not Excel spreadsheets. Go to Insert Field to see the list of valid field codes. "sombera" wrote in message ... I want to create a formula in a word table like the following but everything I have tried, I get a syntax error. Can anyone tell me the correct format for this formula? if (or(c30,d30),sum(e2,c3,d3),"") It's not that complex but I can't get the exact formating down so that it will work. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I enter an if,then,else formula with an embedded sum formul
Both OR and SUM are listed in the "Paste function" list box of Table |
Formula in Word 2003. Both, of course, must be prefaced by = (and { =SUM(ABOVE) } is the probably the most commonly used formula in tables. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Jezebel" wrote in message ... Your main problem is that Word doesn't have OR or SUM functions. Word tables are not Excel spreadsheets. Go to Insert Field to see the list of valid field codes. "sombera" wrote in message ... I want to create a formula in a word table like the following but everything I have tried, I get a syntax error. Can anyone tell me the correct format for this formula? if (or(c30,d30),sum(e2,c3,d3),"") It's not that complex but I can't get the exact formating down so that it will work. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I enter an if,then,else formula with an embedded sum formul
In theory there is nothing wrong with your formula but formulae inWord
fields can be a bit finicky and it seems to want to have a number instead of the quoted empty string. As a way round this you could suppress a zero by doing ... { =if( or( c3 0 , d3 0 ) , sum( e2 , c3 , d3 ) , 0 \# # } -- Enjoy, Tony "sombera" wrote in message ... I want to create a formula in a word table like the following but everything I have tried, I get a syntax error. Can anyone tell me the correct format for this formula? if (or(c30,d30),sum(e2,c3,d3),"") It's not that complex but I can't get the exact formating down so that it will work. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Word table - problem with conditional formula | Tables | |||
Formula to Sum values in word table | Mailmerge | |||
How do I enter a formula in a Word document? | Microsoft Word Help |