# Error- after multiplication shows incorrect value

#### IDRIS86

##### Board Regular
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.

Ruskin-Pricing-R1-07-04-2021 A.xlsx
26DAMPER/BASE PRICESTYLE MULTITOTAL DAMPER
271,0661.001,065.64
28114-114.37
29900-900.44
30458-458.28
314681.40467.55
WORKSHEET
Cell Formulas
RangeFormula
AC27:AC31AC27=(INDEX(INDIRECT(O27&Q27&"A"),XMATCH(M27,INDIRECT(O27&Q27&"H"),1 ),XMATCH(L27,INDIRECT(O27&Q27&"W"),1 )))
Cells with Conditional Formatting
CellConditionCell FormatStop If True
AC28:AC32Cell Value=0textNO
AE27:AE32Cell Value=0textNO
AC27Cell Value=0textNO

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### etaf

##### Well-known Member
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

#### Fluff

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

Replies
18
Views
99
Replies
12
Views
680
Replies
3
Views
1K
Replies
4
Views
521
Replies
8
Views
2K

1,133,269
Messages
5,657,747
Members
418,411
Latest member
Excellency

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back