HI,
I need to compare two cells if it match then return true or false in another cell.but im facing error if one cell have mentioned null value in another cell is blank.Here null and blank value is same but my formula giving false.
formula used:
C3=A2=B2
plz help me
Perhaps
Try
=IF(ISERROR(A2),0)=IF(ISERROR(B2),0)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
You could do this in C2:
=OR(AND(A2="",B2=""),A2=B2)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks