## Multiple ifs, and ands, and are not working

### Multiple ifs, and ands, and are not working

Hello again.

=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E22,"")*IF(AND(H10=4,I10=1),D22","")=IF(AND(H10=4,I10=2),F22,"")*IF(AND(H10=4,I10=0),G22,"")*IF(AND(H10=4,I10=1I22","")

Can This be done or is it a pipe dream

Thanks Allan

### Multiple ifs, and ands, and are not working

What errors are you getting?

Note that you have an = sign between your third and fourth IF statements.
Perhaps that's the source of the problem.

Dave
--
Brevity is the soul of wit.

### Multiple ifs, and ands, and are not working

not sure what you're trying to do, but your syntax is wrong, and if any of
the results wind up giving a null string, the answer will be #VALUE! because
"" times anything gives #VALUE!. MAYBE you want:
=IF(AND(H10=3,I10=1),B22,1)*IF(AND(H10=4,I10=0),E22,1)*IF(AND(H10=4,I10=1),D
22,1)*IF(AND(H10=4,I10=2),F22,1)*IF(AND(H10=4,I10=0),G22,1)*IF(AND(H10=4,I10
=1),I22,1)

??

"A.R.J Allan Jefferys" < XXXX@XXXXX.COM > wrote in

=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E22,"")*IF(AND(H10=4,I10=1)
,D22","")=IF(AND(H10=4,I10=2),F22,"")*IF(AND(H10=4,I10=0),G22,"")*IF(AND(H10
=4,I10=1I22","")

### Multiple ifs, and ands, and are not working

Thanks to you both for the reply, and you are both right. The example that
was for you to see how i could join them into one formula. But I can now see
that only 7 nested functions can go in one formula. So is it Possible to do
this in vb knowing that there will be about 12 functions to be calculated for
each row.