Trouble combining PRODUCT and IF function in same column

[heatblocker10]

Is it possible to combine an IF function with a cell that uses a PRODUCT function as well? I need the output numbers in column K to default to zero if the answer is above 165. The PRODUCT function is dependent on the A and B cell within the same row. Once that answer is determined, if it is below 165 the answer will remain, but if it is above 165 I need it to default to zero. You can see in the attachment that the L column has an IF function that calculates based on the output of K. If K is above 165, column L is activated and gives an output number. Is there someway to include the IF function within the same cell as the answer the IF function depends on? I have not been able to effectively insert a function combining the 2 functions. Instead I have to go down the K column and wherever the L column creates an output, I have to mark out the output number in the K column. Here is the formula for column L : =IF(K5>165,(A5*2+B5*2)*0.78,IF(K5<=165,0)) Essentially the formula for K would be the same thing, but reversed.

[heatblocker10]

Doesn't look like my attachment went through the first time. I'll try again. Excel Worksheet Screenshot.png

[Glenn Kennedy]

is this what you meant?

=IF((A5*2+B5*2)*0.78>=165,0,(A5*2+B5*2)*0.78)

[Glenn Kennedy]

There's a discrepancy between your Post 1 and Post 2. Is it meant to be 0.75 or 0.78?

[heatblocker10]

Am I missing something about posting attachments? Neither one of the screenshots I posted are showing up. I just see a black "X" where the image should be.

Glenn, I'm looking to combine a product and if function together in the same cell.

[heatblocker10]

Am I missing something about posting attachments? Neither one of the screenshots I posted are showing up. I just see a black "X" where the image should be.

Glenn, I'm looking to combine a product and if function together in the same cell.

[Glenn Kennedy]

Let me guess. You're using Internet Explorer... I had this problem until I switched to Firefox. i can see them fine (even thought htey're a bit slow to load). BtW, it's much easier if you post an Excel sheet...

I think the formula above (Post 3) does what you want. Can you check it?

[heatblocker10]

Looks like that solved it! Thank you for the prompt response! I transferred the same equation to the L column and adjusted the variables I needed to and everything is correct now. Thanks again And yes I'm using IE (1990's nostalgia?)

[Glenn Kennedy]

Great. Can you please now mark the thread as solved and (preferably) click the add Reputation button at the foot of this post?

[martindwilson]

factor that down a bit
=IF(2*(A5+B5)*0.78>=165,0,2*(A5+B5))*0.78)