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]

Forgot the brackets:

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

 

[Aladin Akyurek]

On 2002-11-08 01:06, simonf wrote:
Forgot the brackets:

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

Now post the formula with IF that doesn't work (no Html please).

 

[simonf]

IF(G1="CAD", (SUMPRODUCT((THREED(Sheet2:Sheet4!B1))*($C$17:$C$19))+SUMPRODUCT((THREED(Sheet5:Sheet7!B1))*($C$20:$C$22))/$E$1), (SUMPRODUCT((THREED(Sheet2:Sheet4!B1))*($C$17:$C$19))*$E$1+SUMPRODUCT((THREED(Sheet5:Sheet7!B1))*($C$20:$C$22))))

Here it is. Thanks Aladin.

 

[Ekim]

What is THREED?

Is it some exotic function that I should know about?

Regards,

Mike

 

[Aladin Akyurek]

On 2002-11-08 02:36, simonf wrote:
IF(G1="CAD", (SUMPRODUCT((THREED(Sheet2:Sheet4!B1))*($C$17:$C$19))+SUMPRODUCT((THREED(Sheet5:Sheet7!B1))*($C$20:$C$22))/$E$1), (SUMPRODUCT((THREED(Sheet2:Sheet4!B1))*($C$17:$C$19))*$E$1+SUMPRODUCT((THREED(Sheet5:Sheet7!B1))*($C$20:$C$22))))

[...]

Do the Then-part and Else-part work, when used separately, as intended?

 

[simonf]

Yes, when use seperately without the IF joining, each part works.

THREED is part of a third party add-in 3D function. Aladin recommended it to me. You can download it from

http://longre.free.fr/index.html

 

[Aladin Akyurek]

On 2002-11-08 12:43, simonf wrote:
Yes, when use seperately without the IF joining, each part works.[...]

What is the result of...

=LEN(G1)?