Forum Discussion

Copper Contributor

Mar 31, 2021

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

Formulas and Functions

NikolinoDE
Mar 31, 2021
Hydro222
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)
AAAAA_TEST SHEET.xlsx12 KB

Riny_van_Eekelen

Platinum Contributor

Mar 31, 2021

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.

Hydro222
Copper Contributor
Mar 31, 2021
Thank you for the reply. I need it to calculate the sum as well.
- Riny_van_Eekelen
  Platinum Contributor
  Apr 01, 2021
  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.
  - Hydro222
    Copper Contributor
    Apr 01, 2021
    Great job on putting a condensed formula together. I like this . Thank you!