Error- after multiplication shows incorrect value

IDRIS86

Board Regular
Joined
Mar 18, 2021
Messages
78
Office Version
  1. 365
Platform
  1. Windows
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
ACADAE
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 )))
AD27:AD31AD27=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:AE31AE27=IF(AND($N27="FSD",$N27="SD",$N27="CD",$N27="SD"),AC27*AD27,AC27)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
AD28:AD32Cell Value=0textNO
AC28:AC32Cell Value=0textNO
AE27:AE32Cell Value=0textNO
AD27Cell 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
Joined
Oct 24, 2012
Messages
4,761
Office Version
  1. 365
Platform
  1. MacOS
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,413
Office Version
  1. 365
Platform
  1. Windows
N27 cannot equal 3 different values at the same time, should the formula be OR instead of AND?
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top