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.

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

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

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

1. two questions: and's inside if's and checking the return code of a program

2. IF's & AND's

3. Nesting IF's and AND's - a bit of help please...

4. Problem with calculations and multiple AND's in criteria

6. Stenciling and multiple buffer "ands"

7. WMP11 BUG: Advanced Search doesn't work with ANDs

8. Conditional Statement with ANDs

9. i start computer i get a override message ands puter wont start

10. Wireless Authentication ands Ecryption Question

11. Specify list items with unlimited ANDs and ORs?

12. Proper way to write a conditional statement with ands

14. Using embeded AND's in WHERE clause?

4 post • Page:**1** of **1**