Forum Discussion
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 has no value (blank)
Thank you
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)
10 Replies
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! That works perfect!
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.
- 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.
Please Read this Post with help.
https://techcommunity.microsoft.com/t5/excel/welcome-to-your-excel-discussion-space/m-p/2204395
From your post, I can not see with what and who it should be multiplied, for example 0.51 or 51st
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- 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.
