THREED function question

[simonf]

Book2(1).xls
	A	B	C	D	E	F	G
1	Amortization&depreciation	267		F/XRATE	1.5		CAD
2	Bankcharges	400
3	Interestexpense	644
4	Managementfees	70,412
5	Officeexpense	24,106
6	Payroll	-
7	Professionalfees	49,859
8	Promotion	3,720
9	Rent	-
10	Rentals	-
11	Telephone	-
12	Training	763,385
13	Travel	-
14
15
16
17	Sheet2	y	1
18	Sheet3	y	1
19	Sheet4	y	1
20	Sheet5	y	1
21	Sheet6		0
22	Sheet7	y	1
Sheet1

Why are the cells picking up the wrong numbers? The numbers also changes everytime I change the value in C17:C19. The data sheets follow.

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	0
2	Bankcharges	0
3	Interestexpense	0
4	Managementfees	29,493
5	Officeexpense	36,158
6	Payroll	0
7	Professionalfees	74,788
8	Promotion	5,580
9	Rent	0
10	Rentals	0
11	Telephone	0
12	Training	1,145,078
13	Travel	0
Sheet2

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	400
2	Bankcharges	100
3	Interestexpense	300
4	Managementfees	40,325
5	Officeexpense	0
6	Payroll	0
7	Professionalfees	0
8	Promotion	0
9	Rent	0
10	Rentals	0
11	Telephone	0
12	Training	0
13	Travel	0
Sheet3

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	0
2	Bankcharges	500
3	Interestexpense	667
4	Managementfees	35,800
5	Officeexpense	0
6	Payroll	0
7	Professionalfees	0
8	Promotion	0
9	Rent	0
10	Rentals	0
11	Telephone	0
12	Training	0
13	Travel	0
Sheet4

 

[simonf]

Darn, this example is not working well. I just realize the F/X division but the one from my work which looks almost like this has the problem I described. I'll repost later. Sorry for the trouble.

 

[simonf]

Book2(1).xls
	A	B	C	D	E	F	G
1	Amortization&depreciation	783		F/XRATE	1.5		CAD
2	Bankcharges	1,175
3	Interestexpense	1,500
4	Managementfees	1,500
5	Officeexpense	126
6	Payroll	126
7	Professionalfees	4,000
8	Promotion	4,000
9	Rent	-
10	Rentals	-
11	Telephone	-
12	Training	-
13	Travel	4,000
14
15
16
17	Sheet2		0
18	Sheet3	y	1
19	Sheet4	y	1
20	Sheet5	y	1
21	Sheet6	y	1
22	Sheet7		0
Sheet1

Ok, here it is. Notice cells seem to be duplicating? I'll post the other sheet up.

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	350
2	Bankcharges	25
3	Interestexpense	0
4	Managementfees	0
5	Officeexpense	100
6	Payroll	0
7	Professionalfees	3,500
8	Promotion	0
9	Rent	0
10	Rentals	0
11	Telephone	0
12	Training	0
13	Travel	4,000
Sheet5

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	0
2	Bankcharges	250
3	Interestexpense	50
4	Managementfees	6,750
5	Officeexpense	26
6	Payroll	0
7	Professionalfees	500
8	Promotion	1,500
9	Rent	0
10	Rentals	220
11	Telephone	0
12	Training	10,875
13	Travel	0
Sheet6

 

[simonf]

Book2(1).xls
	A	B	C	D
1	Amortization&depreciation	610
2	Bankcharges	100
3	Interestexpense	200
4	Managementfees	129,284
5	Officeexpense	0
6	Payroll	0
7	Professionalfees	0
8	Promotion	0
9	Rent	0
10	Rentals	0
11	Telephone	0
12	Training	0
13	Travel	0
Sheet7

 

[simonf]

Humm, looks like if I don't use the IF statement, it works.

SUMPRODUCT((THREED(Sheet2:Sheet4!B12))*($C$17:$C$19))+SUMPRODUCT((THREED(Sheet5:Sheet7!B12))*($C$20:$C$22))/$E$1

Any ideas why the IF doesn't work?