Assign values and calculate

[Sun State Systems]

I have a column with different cost multipliers in it (i.e. A12, A4, A1M). I am trying to create a formula that will assign a numeric value to each of these multipliers and then multiply that value by the list price (which is in another column) and have the result (our cost) show up in a column.

 

[Somendra Misra]

Hi,

What values are you expecting to assign and with what logic, can you share a sample file???

Regards,

 

[Sun State Systems]

I want to assign a numeric value to each Bulletin (Ex. 12E = .3267). I then want that value to be multiplied by the List Price to calculate our cost. I have 15-18 different multipliers and thousands of line items on my spreadsheet so I want one formula instead of having to do a formula on each line item for each bulletin. For example can the formula "say", If 12E = .3267, multiply A2 by .3267, if H76 = .3554, multiply A2 by .3554., if J5E = .4267, multiply A2 by .4267.

 

[Faseeh]

Hi @Sun State Systems,

Can you provide an excel sheet for this data just a small bunch of rows.

 

[Somendra Misra]

See the file. You can expand the lookup table.

Regards,