Forum Discussion
Hydro222
Mar 31, 2021Copper Contributor
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...
- Mar 31, 2021
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)
Hydro222
Mar 31, 2021Copper Contributor
Thank you for the reply. I need it to calculate the sum as well.
Riny_van_Eekelen
Apr 01, 2021Platinum Contributor
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*K3
as in Quantity times Unit cost.
- Hydro222Apr 01, 2021Copper ContributorGreat job on putting a condensed formula together. I like this . Thank you!