How do I enter an if,then,else formula with an embedded sum formul

S

sombera

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.
 
J

Jezebel

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.
 
S

Suzanne S. Barnhill

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.
 
T

Tony Jollans

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 \# # }
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top