A value used in the formula is of the wrong data type.

[wynandbecker]

I'm multiplying four cells in a row, the first one is looked up and the other three are just numbers, but I receive wrong data type error.

COSTMASTERv7.0_NOV2022.xlsx
	A		C		E		G	H	I	J	K	L	M	N	O	P		R		T		V		X	Y	Z	AA
11	CATEGORY							HOURS																SHIFT		LINE
12
13								N/T			O/T			D/T										ALLOWANCE	ALLOWANCE	TOTAL
14			SELLING		SELLING		SELLING	PEOPLE	DAYS	HRS P/D	PEOPLE	DAYS	HRS P/D	PEOPLE	DAYS	HRS P/D		SELLING		SELLING		SELLING		%	TOTAL	COST	SELLING
15	BOILERMAKER		R495.00		R780.00		R1,040.00	1	1	1	1	1	1	1	1	1		#VALUE!		#VALUE!		#VALUE!			#VALUE!	#VALUE!	#VALUE!
16	MILLWRIGHT		R495.00		R780.00		R1,040.00											R0,00		R0,00		R0,00			R0,00	R0,00	R0,00
17	SEMI-SKILLED		R235.00		R352.50		R470.00											R0,00		R0,00		R0,00			R0,00	R0,00	R0,00
18	ELECTRICIAN		R495.00		R780.00		R1,040.00											R0,00		R0,00		R0,00			R0,00	R0,00	R0,00
LABOUR

Cell Formulas
Range	Formula
C15:C18	C15	=INDEX(LABOUR_PRICING!$D$4:$AV$30,MATCH(A15,LABOUR_PRICING!$B$4:$B$30,0),MATCH($A$1,LABOUR_PRICING!$D$2:$AV$2,0))
E15:E18	E15	=INDEX(LABOUR_PRICING!$D$35:$AV$61,MATCH(A15,LABOUR_PRICING!$B$4:$B$30,0),MATCH($A$1,LABOUR_PRICING!$D$2:$AV$2,0))
G15:G18	G15	=INDEX(LABOUR_PRICING!$D$66:$AV$92,MATCH(A15,LABOUR_PRICING!$B$4:$B$30,0),MATCH($A$1,LABOUR_PRICING!$D$2:$AV$2,0))
R15:R18	R15	=SUM(C15*H15*I15*J15)
T15:T18	T15	=SUM(E15*K15*L15*M15)
V15:V18	V15	=SUM(G15*N15*O15*P15)
Y15:Y18	Y15	=R15*(X15/100)
Z15:Z18	Z15	=SUM(Q15,S15,U15,W15)+(Y15/1.35)
AA15:AA18	AA15	=SUM(R15,T15,V15,Y15)

Cells with Data Validation
Cell	Allow	Criteria
A15:A18	List	=LABOUR_PRICING!$B$4:$B$30

 

[Peter_SSs]

It appears that the looked up value is text and therefore cannot be multiplied as a number.
Try this in cell R15

=SUBSTITUTE(C15,"R","")*H15*I15*J15

 

[wynandbecker]

It appears that the looked up value is text and therefore cannot be multiplied as a number.
Try this in cell R15

=SUBSTITUTE(C15,"R","")*H15*I15*J15

ty Peter_SSs - I tried your suggestion but still Wrong data type

 

[wynandbecker]

ty Peter_SSs - I tried your suggestion but still Wrong data type

I fixed it. It was my desimals/thousands separators that didn't match the sheet's! ty

 

[Peter_SSs]

Glad you got it sorted. Thanks for letting us know what was happening.