Multiplying by a specific cell in a table

[Drece-gkn]

Hello, 

First let me show you the screenshot of my table to help get a understanding of my data. 

To the left of total sales(a) are Part numbers but I am not allowed to show those. In order to explain what I am trying to accomplish I will call the 3 part numbers A, B and C. Part number A = $857,004(Total Sales), but I need to split this cost between the 3 parts and put that cost in the new column "Consumption". I successfully split the total sales for part number A using the equation If([Material Number] = 'A', [Total Sales]*.6, which equals that $514,202.40 number you see. But I have not been able to figure out how to split it for B and C. Basically, for part number B and C I need to multiply the Total sales of part number A by .4. The equation I was trying to use was If([Material Number] = 'B' or [Material Number = 'C', if([Material Number] = 'A', [Total Sales]*4,' '))), but this does not work. I know the nested If isn't correct but I haven't been able to figure out the logic I need to use to solve this. Any Ideas?

[vinieme12]

can you post some sample dummy data with expected outputs?

[Drece-gkn]

Expected results would be for Material Number A $857,004(Total Sales) *.6 = $514,202.4. Then for Material Number B and C we want to take the Total sales of A ($857,004) *.4 = $342.801.6. So, I would expect that total to show up in the consumption column for the Material Number B and C row.