Need to compare 3 columns and return value

 kk -

I need write a macro
There are 3 columns in a sheet which has Y & N. If Y is found then it is should give comment in 4th column as No action required.
Please help

3 replies

Hi. you can use the if formula

=IF(A2="N",IF(B2="N",IF(C2="N","","No Action Require"),"No Action Require"),"No Action Require")
a b c comment
n n n
n y n No Action Require
y n n No Action Require
n n y No Action Require
Can you please let me know how to write the same using the macro