IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Help needed 0
Fill a blank cell with a value using if conditions 7
Formula? 14
Formula 0
IF Statements 3
Need help in Defining Criteria for Range 1

Back
Top