Hey guys, I'm trying to do something really basic for a spreadsheet I'm making for working with stocks. Basically it's aim is to calculate net profits/loss on a stock depending on different sell prices. Here's how it works:

1) Number of shares = X
2) Purchase price (cost per share) = Y
3) Sell price (cost per share) = Z
4) Sell price increment (ex: sell price of $10.00, increment of $0.10) = N
5) Commission fee = {[(X*Y)+(Y*Z)]}*0.005+14

The calculation should look something like this:

X*Z - X*(Y+N) - commission fee = net profit/loss

So here's what I need to do and what I'm having trouble accomplishing. I need the results to come out on multiple rows with each row incrementing by the price increment N. So if someone enters $0.10 then the first row displays the profit/loss *without* the increment, the second row would take into account N*1, the second N*2, the third N*3, etc.

Here's the equation I have so far (as it appears in Excel), although it isn't working:

PHP Code: 
=(A2*C2)-(A2*B2)-(0.005*((A2*(C2+(D2*1))+(A2*B2))+14)) 
A=number of shares, B=purchase price, C=sell price, D=price increment. E2 should display the value of C while E3 and beyond is the value of C plus D's incrementally increasing value.

Help!

Thanks everyone!