Multiple ifs, and ands, and are not working
 

Hello again.

=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E 22,"")*IF(AND(H10=4,I10=1),D22","")=IF(AND(H10=4,I 10=2),F22,"")*IF(AND(H10=4,I10=0),G22,"")*IF(AND(H 10=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.


"A.R.J Allan Jefferys" wrote:

Hello again.

=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E 22,"")*IF(AND(H10=4,I10=1),D22","")=IF(AND(H10=4,I 10=2),F22,"")*IF(AND(H10=4,I10=0),G22,"")*IF(AND(H 10=4,I10=1I22","")

Can This be done or is it a pipe dream

Thanks Allan

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),E2 2,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" wrote in
message ...
Hello again.


=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E 22,"")*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
 

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