how to use the If function in tables in Word

P

PeterB

In word I made a table with 3 cells (A1, B1 and C1), A1 and B1 are filled
with a number. In C1, the highest value of A1 and B1 has to be denoted. I use
the expression: { =IF(A1 >= B1 A1 B1) \# "0"} unfortunately this expression
won't work. I continuously get syntax errors. Why? What am I doing wrong? Can
anyone help me? The Word help assistance is not very helpful
 
G

Greg Maxey

Peter,

You are missing commas between the expression and the two alternative
results

{ =if(a1>=b1,a1,b1) }
 
D

Doug Robbins

Use {= { IF A1 >= B1 A1 B1 } \# "0" }

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
P

PeterB

In the mean time, I found the answer of my own question.
The Microsoft help was incorrect. in general, the IF statement works as
follows:
{ IF(Expression1 Operator Expression2; TrueText; FalseText) }

Good luck to all!

Greetings,
Peter
 
G

Greg

I don't know what your system settings are, but with the "=" sign in
front of the IF I don't see how your expression works at all. Here the
separators ";" return a syntax error. This works: { =if(a1>=b1,a1,b1)
}
 

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