 SOLVED

# 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

10 Replies

# Re: Multiplier if a cell =P

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)

# Re: Multiplier if a cell =P

@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.

# Re: Multiplier if a cell =P

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.

# Re: Multiplier if a cell =P

Open full text editor

Drag and drop here or browse files to attach

Maximum size: 71 MB • Maximum attachments allowed: 5

# Re: Multiplier if a cell =P

Thank you for the reply. I need it to calculate the sum as well.

# Re: Multiplier if a cell =P

best response confirmed by Hydro222 (Occasional Contributor)
Solution

# Re: Multiplier if a cell =P

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)

# Re: Multiplier if a cell =P

Thank you! That works perfect!

# Re: Multiplier if a cell =P

@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.

# Re: Multiplier if a cell =P

Great job on putting a condensed formula together. I like this . Thank you!