ExcelBanter - excel formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel formulas (https://www.excelbanter.com/excel-discussion-misc-queries/24170-excel-formulas.html)

In J5 I have the following formula
=IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6,"")
This is based on selling product "A" in B5.
If we sell product "B,C,D,E etc." I would like to add to the formula
E5-2.35*D5 to J5.
Thanks in advance for your help!!!

if I am reading your statement correctly
=IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6
+ if(or(B5="B",B5="C",B5="D",b5="E"),E5-2.35*D5,""),"")

would do it.

I am not comfortable I know what you want

"Dave O." wrote:

In J5 I have the following formula
=IF((D6<"")*(E6<""),LOOKUP(E6,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D6-H6,"")
This is based on selling product "A" in B5.
If we sell product "B,C,D,E etc." I would like to add to the formula
E5-2.35*D5 to J5.
Thanks in advance for your help!!!