IF Formula

=IF(AND(OR(C34=1,D34=1,E34=1,F34=1,G34=1)*C35=1),”TRUE”,””)

Hello, I have the formula above working but its not quite right.

I am basically trying to say if any cell in the range C34:g34 has a 1 in it plus c35 has a 1 in it then return a TRUE value.

This works ok.

I now want to expand this to any cell in the range c34:g34 with a 1 in it + any cell in the range below (c35:g35) with a 1 in it then return a TRUE value.

I cant get the formula to expand to this ?

This is my take :

=IF(AND(OR(C34:G34=1) & =IF(AND(OR(C35:G35=1),”TRUE”,””)

This doesnt work ? Any ideas were im going wrong ?

By: James

Leave a Reply

Your email address will not be published. Required fields are marked *