Need to compare 3 columns and return value Closed

Question

Hello,

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

hoot · Answer

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")

hoot · Answer

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

kk · Answer

Can you please let me know how to write the same using the macro

Need to compare 3 columns and return value

3 responses

Subscribe To Our Newsletter!