Forum Discussion
IF Statement with multiple answers
I see. And how do you define which lines to pickup? In your formula
=IF(B8=1,G8,IF(B14=1,G14,IF(B23=1,G23,"Nothing noted in this section")))
that is first line in first and second groups (B1, B14) and the last line in the third groups (G23). You'd like to combine positions manually, or we take all first positions where 1, into another cell all second positions with 1, etc.
If manually that could be
=IF( (B8=1)+(B14=1)+(B23=1), IF(B8=1,G8 & " ", "") & IF(B14=1,G14 & " ","") & IF(B23=1,G23, ""),"Nothing noted in this section")
and in cell D25 attached
I pick all the lines that have red answers, just incase they pick that answer, but only the ones that are picked will the answers print. Does that make sense?
do I need these three below?
(B8=1)+(B14=1)+(B23=1)
Linda, it's possible but bit hard to automate selection of answers based on colour. You have some numbers in column F, better based on them. Let say
if any of b8:b11 is equal to 1 then add answer where F8:F11 is equal to 3,5,7 or 10 depends on the position of 1 in b8:b11, else nothing
and combine above for all groups.
(B8=1)+(B14=1)+(B23=1) means you have 1 at least in one of these cells, thus some answers from G picked-up, otherwise nothing is noted