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, I running Win10 with Office 2016.
Do not see how to add a file?
What I have is column (C) has list price. Column (J) would have cost based on using a multiplier of .49 So if C = 1.50 then J = .735 except when column (G) has a alpha value "P" then the multiplier changes to .51
I haven't been able to figure out how to write the formula.
Do not see how to add a file?
What I have is column (C) has list price. Column (J) would have cost based on using a multiplier of .49 So if C = 1.50 then J = .735 except when column (G) has a alpha value "P" then the multiplier changes to .51
I haven't been able to figure out how to write the formula.
NikolinoDE
Mar 31, 2021Platinum Contributor