Hey guys,
I'm just wondering if anyone can help me with writing a formula for comparing values in 2 columns and ignore blank cells please?
For the example below:
If the values match or if there's a blank, then show up as "Okay"
If the values do not match, then show up as "Bad"
Thanks so much in advance for any help!
I'm just wondering if anyone can help me with writing a formula for comparing values in 2 columns and ignore blank cells please?
For the example below:
If the values match or if there's a blank, then show up as "Okay"
If the values do not match, then show up as "Bad"
A | B | C | D |
Item 1 | 3 | Okay | |
Item 3 | 2 | 2 | Okay |
Item 4 | 4 | 5 | Bad |
Thanks so much in advance for any help!