When said cell is blank, one formula is used, but if number, another formula.

[TobyB]

I am trying to get the formula figured out for cell Q4, but ultimately, all the cells in P&Q. If I get the formula for Q4, I can figure out the rest. Since I am not very proficient at Excel, I just got lost.

Here is what I want to happen in cell Q4;
A: (If there is a number in J column) Take the number in column B, subtract column I, column J times the quantity in column K, minus column L.
Next, divide that number by the quantity
in column K plus 1 (in other words, is the qty was 1, it would be divided by two; is the qty was 2, it would be divided by three, etc)
Lastly, add the number in N2.
Anybody lost yet? Now for the simple one.

B: (If there is no number in J column) Take the number in column B, subtract column I, & column L.
Lastly, add the number in N2.

See the attached worksheet.
Thanks so much for looking!
Toby B

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[TobyB]

It was almost right. I changed the formula to =IF(J4<>"",((B4-I4-(J4*K4)-L4)/(K4+1))+$N$2,(B4-I4-L4)+$N$2) , and the end number came out correctly. If I remember correctly the I4 was missing.
Attached is the final worksheet.


Thanks so much for your help! I really appreciate your time and effort!
Toby B