Forum Discussion
Multiplier if a cell =P
- 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 In it's simplest form that could be
=IF(G11="P",0.51,0.49)
This will test for G11 = "P". If so, take 0.51. If it is not, then take =0.49. So, if the value in G11 is not equal to P (i.e. blank or anything else) 0.49 will be returned.
- Hydro222Mar 31, 2021Copper ContributorThank you for the reply. I need it to calculate the sum as well.
- Riny_van_EekelenApr 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!