IF statement

R

Ragnar

In excel If 2 columns have an equal value I want a 3rd column to display the
value from a 4th column, what is the syntax for this?
 
S

Sandy Mann

Ragnar,

You don't say what you want if the values are not equal but the general
syntax for an IF statement is:

=IF(test, Do if test true, Do if test not true)
so in your case that would be:

=If(1st Column Value=2nd Column Value,Value from 3rd Column,Result if not
equal)

One caveat is if the 1st and 2nd values are determined by a calculation they
may differ by just a very small amount which would sop them being equal and
so you may have to round them before comparing.

HTH

Sandy
 

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