MrExcel Publishing
Your One Stop for Excel Tips & Solutions

can' use the =


Posted by John Adair on September 03, 2001 8:31 PM

VMATW 8/31/2001 44.1 0.14% 4 wks MATW 43.95 -0.20% 4 wks 1 0 0.14

MATW 8/31/2001 44.1 0.14% 4 wks MATW 43.95 -0.20% 4 wks 1 0 0.14

I am trying to use the equal in an If statement but it does not work what am I doing wrong
Here is an example.
"jakk" in col a "jakk" in col b
=if (col a =colb),col c,0
It wont get col c for me I get a 0
What am I doing wrong


Posted by anno on September 03, 2001 9:11 PM

john
try =IF(A1=B1,C1,0) - your bracket placing is out of whack.