S
Str8goofE
Hi again,
I am trying to reconfigure my formula so that if A2 is EXACTLY equal to any
cell in the range B2 to B5, display a 1 in cell C2, else display a 0 in cell
C2.
Am I close with these formulas???
=SUM(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0)
=IF(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0)
I am trying to reconfigure my formula so that if A2 is EXACTLY equal to any
cell in the range B2 to B5, display a 1 in cell C2, else display a 0 in cell
C2.
Am I close with these formulas???
=SUM(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0)
=IF(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0)