How do I enter an if,then,else formula with an embedded sum formul sombera 25.09.2006 20:52:01 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(c3<>0,d3<>0),sum(e2,c3,d3),"") It's not that complex but I can't get the exact formating down so that it will work.

Re: How do I enter an if,then,else formula with an embedded sum formul "Jezebel" <warcrimes[ at ]whitehouse.gov> 25.09.2006 21:16:17 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" <sombera[ at ]discussions.microsoft.com> wrote in message news:748F2F92-EFD6-49CE-B2EF-BB2C20B9EB45[ at ]microsoft.com... [Quoted Text] >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(c3<>0,d3<>0),sum(e2,c3,d3),"") > > It's not that complex but I can't get the exact formating down so that it > will work.

Re: How do I enter an if,then,else formula with an embedded sum formul "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 25.09.2006 21:59:21 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" <warcrimes[ at ]whitehouse.gov> wrote in message news:OLZ7TfO4GHA.1568[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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" <sombera[ at ]discussions.microsoft.com> wrote in message > news:748F2F92-EFD6-49CE-B2EF-BB2C20B9EB45[ at ]microsoft.com... > >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(c3<>0,d3<>0),sum(e2,c3,d3),"") > > > > It's not that complex but I can't get the exact formating down so that it > > will work. > >

Re: How do I enter an if,then,else formula with an embedded sum formul "Tony Jollans" <my forename at my surname dot com> 26.09.2006 11:01:32 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" <sombera[ at ]discussions.microsoft.com> wrote in message news:748F2F92-EFD6-49CE-B2EF-BB2C20B9EB45[ at ]microsoft.com... [Quoted Text] > 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(c3<>0,d3<>0),sum(e2,c3,d3),"") > > It's not that complex but I can't get the exact formating down so that it > will work.