Forum Discussion
IF Statement with multiple answers
4 this cell to print 4 and this cell as well 4 and this cell as well HI guys, I thought I had IF statements down, but this one is not working for me. What I am trying to do in one ce...
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)