I would like for field to look at a range of yes/no/n/a questions then change the value to yes of all responses are yes or yes's and n/a. change value to red if a no is in the range. also want the filed to be blank by default. see attached.
I would like for field to look at a range of yes/no/n/a questions then change the value to yes of all responses are yes or yes's and n/a. change value to red if a no is in the range. also want the filed to be blank by default. see attached.
Last edited by korr77; 03-15-2010 at 08:22 AM.
Try:
=IF(COUNTA($C$4:$C$12),IF(COUNTIF($C$4:$C$12,"No"),"No","Yes"),"")
but you should remove data validation from that cell, or you could end up overwriting the formula.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Works great...can you modify the formula to return a N/A result if all choices in the range are N/A?
Try:
=IF(COUNTA($C$4:$C$12),IF(COUNTIF($C$4:$C$12,"N/A")=COUNTA($C$4:$C$12),"N/A",IF(COUNTIF($C$4:$C$12,"No"),"No","Yes")),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks