Forum Discussion
JENNIFR GARRETT
Feb 22, 2017Copper Contributor
Help creating an equal equation
Can you please help me creat a equal equation that will look to see if the numnber in colunm A is the same in column B
2 Replies
- Joshua AdesojiCopper Contributor
Hi Jennifer,
You can place this formula in cell C1 =IF(A1=B1,"Same","Not Same").
It will return "Same" if the numbers or values in Columns A and B are same, and return "Not Same" if otherwise.
Meanwhile, you can change the return values to "True and False" if you so wish.
Cheers!
JENNIFR GARRETT wrote:Can you please help me creat a equal equation that will look to see if the numnber in colunm A is the same in column B
- Detlef_LewinSilver Contributor
Hello Jennifr
=A1=B1