Multiple ifs, and ands, and are not working

[A.R.J Allan Jefferys]

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

 

[Dave F]

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

 

[Bob Umlas]

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]

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.

Thanks again in advance

Allan