Jaimee001
Member
Hi there folks, it's been a few weeks since I've been here. I have a report
that includes (A) ACCT_NO, (B)SUBM_CODE AND (C)SETTLE CODE. IN column D I want to use a formula where if B and C match then a Y if not a N. This is what I've used in the past:
IF(B5=C5,"Y","N")
However the data has changed and now some accounts don't have a SUBM CODE or a SETTLE CODE, so that would result in an N but that's not correct. I only want the Y or N when there is both the subm code and settle code.
In the rows where there is a blank in either SUBM CODE or SETTLE CODE I'd like the formula results to be blank....hopefully that makes sense.
Here the link to my file: http://speedy.sh/x3VxF/Example-for-Y-N-with-Nulls.xlsx
Thanks in advance....
that includes (A) ACCT_NO, (B)SUBM_CODE AND (C)SETTLE CODE. IN column D I want to use a formula where if B and C match then a Y if not a N. This is what I've used in the past:
IF(B5=C5,"Y","N")
However the data has changed and now some accounts don't have a SUBM CODE or a SETTLE CODE, so that would result in an N but that's not correct. I only want the Y or N when there is both the subm code and settle code.
In the rows where there is a blank in either SUBM CODE or SETTLE CODE I'd like the formula results to be blank....hopefully that makes sense.
Here the link to my file: http://speedy.sh/x3VxF/Example-for-Y-N-with-Nulls.xlsx
Thanks in advance....
