Forum Discussion
Solved
how to treat the null
Hello All, I need help in comparing two columns and find out if its match or mismatch. And I need to exclude the amount which is in credit and I need to exclude blank cells in Column B & C. The...
Hi,
If you mean to exclude if any of B or C is blank when it could be
=IF((A2>0)*LEN(B2)*LEN(C2)*(B2<>C2),"Mismatch","")
and attached
Hi,
If you mean to exclude if any of B or C is blank when it could be
=IF((A2>0)*LEN(B2)*LEN(C2)*(B2<>C2),"Mismatch","")
and attached
Thank you. This will help.
How do I add trim condition for B2 & C2 in the same formula?
Regards,
Chandrakanth.K
If you mean to remove all spaces you may use TRIM(B2) and TRIM(C2) instead of B2 and C2
Hello Sergei,
Do I need to replace LEN with Trim or do I need to add Trim after Len? I am getting error stating "to many arguments" when I add Trim after Len.
Regards,
Chandrakanth.K
That's like
=IF((A2>0)*LEN(TRIM(B2))*LEN(TRIM(C2))*(TRIM(B2)<>TRIM(C2)),"Mismatch","")
and attached