Need to compare 3 columns and return value

kk - Jan 3, 2010 at 10:25 PM
 kk - Jan 5, 2010 at 12:06 AM

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