Forum Discussion
Solved
Multiplier if a cell =P
So I have a cost speadsheet that I need to calculate cost. There are two multipliers used from the list price column depending on the product. So I need to use .51 if cell G11 = P and .49 if the cell...
Please have a look at the inserted worksheet.
As I understand it, I have implemented the formula in columns J & K.
Thank you for you all understanding and patience
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Thank you for the reply. I need it to calculate the sum as well.
Hydro222 In case you are interested in another solution. Consider this.
In J, calculate unit cost as:
=C3*(0.49+(G3="P")*0.02)It takes the list price from C and multiplies it by either 0.49 or ( 0.49 plus an extra 0.02 ), in case G contains the letter P.
Calculate extended cost in I as:
=D3*K3as in Quantity times Unit cost.
- Great job on putting a condensed formula together. I like this . Thank you!