Developer Forum

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

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.

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","")

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