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.
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 |