Error- after multiplication shows incorrect value

[IDRIS86]

Hi,

The values in AC31 & AD31 are getting multiplied to provide result in AE31. like 468 x 1.4, should be 655.2. But it shows still 468. I check the formula, it has multiplication, but not showing correct value.

Please assist.

Ruskin-Pricing-R1-07-04-2021 A.xlsx
	AC	AD	AE
26	DAMPER/BASE PRICE	STYLE MULTI	TOTAL DAMPER
27	1,066	1.00	1,065.64
28	114	-	114.37
29	900	-	900.44
30	458	-	458.28
31	468	1.40	467.55
WORKSHEET

Cell Formulas
Range	Formula
AC27:AC31	AC27	=(INDEX(INDIRECT(O27&Q27&"A"),XMATCH(M27,INDIRECT(O27&Q27&"H"),1 ),XMATCH(L27,INDIRECT(O27&Q27&"W"),1 )))
AD27:AD31	AD27	=IFERROR(IF($S27="YES",INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(WORKSHEET!$O27&WORKSHEET!$P27,'PRICE LIST'!$A$7368:$A$7679&'PRICE LIST'!$B$7368:$B$7679,0)),0),"")
AE27:AE31	AE27	=IF(AND($N27="FSD",$N27="SD",$N27="CD",$N27="SD"),AC27*AD27,AC27)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AD28:AD32	Cell Value	=0	text	NO
AC28:AC32	Cell Value	=0	text	NO
AE27:AE32	Cell Value	=0	text	NO
AD27	Cell Value	=0	text	NO
AC27	Cell Value	=0	text	NO

 

[etaf]

Whats actually in AC31 = 467.55 rounded up to show 468?

$N27="FSD",$N27="SD",$N27="CD",$N27="SD
EDIT - HOW CAN the SAME CELL contain all those items and be TRUE - Its never going to do the TRUE multiplication - AS THEY ALL have to be TRUE - HENCE THE AND()
you could change that formula as a TEST
=IF(AND($N27="FSD",$N27="SD",$N27="CD",$N27="SD"),AC27*AD27,"AND not met!!!")

=IF(AND($N27="FSD",$N27="SD",$N27="CD",$N27="SD"),AC27*AD27,AC27)

 

[Fluff]

N27 cannot equal 3 different values at the same time, should the formula be OR instead of AND?