L
Legacy 385836
Guest
Hi
I have a spreadsheet to check compliance. I have 3 columns, 2 of which are yes/no and the third is yes/no/N/A.
I need the final column to display No if any of the previous 3 columns show No, and to display yes if al the columns are yes or n/a.
I have tried to use an IF statement and nested IF statements with no luck.
Any help Would be much appreciated.
Thanks.
I have a spreadsheet to check compliance. I have 3 columns, 2 of which are yes/no and the third is yes/no/N/A.
I need the final column to display No if any of the previous 3 columns show No, and to display yes if al the columns are yes or n/a.
I have tried to use an IF statement and nested IF statements with no luck.
Any help Would be much appreciated.
Thanks.