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)
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)
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.
- NikolinoDEMar 31, 2021Platinum Contributor