Mar 31 2021 09:22 AM
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
Mar 31 2021 09:43 AM
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)
Mar 31 2021 11:56 AM
@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.
Mar 31 2021 11:56 AM
Mar 31 2021 12:02 PM
Mar 31 2021 12:02 PM
Mar 31 2021 12:19 PM
SolutionPlease 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)
Mar 31 2021 09:09 PM
@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.
Apr 01 2021 07:23 AM
Mar 31 2021 12:19 PM
SolutionPlease 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)