Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement
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? |
#2
|
|||
|
|||
One way:
C1: =IF(A1=B1,D1,"") In article , Ragnar wrote: 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? |
#3
|
|||
|
|||
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 -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Ragnar" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
=IF statement | Excel Discussion (Misc queries) |