In D1, put the following formula:
=IF(A1=A2,B2,"")
That last "" takes care of the "else" part of your equation--in other words,
what to do in D1 if A1 does not equal A2.
"Christina" wrote:
2Please help with the syntax for the following:
If the contents in A1 = the contents in A2, put the contents of B2 in D1.
Thanks, ck
|