formula that include variables to graph

[bademployee]

Hi all


I'm trying to come up with a suitable formula for the first cell for a 60 month period graph, according to input here:

[/IMG]




Number of contracts =J16*J11/(F21*N11)

Don't take any notice of the box labelled "Compound", this will apply from the 2 month period onwards, think I can work this out myself.

I got to: =SUM(B16*J11/(F21*N11))*(B6*F6*N11*B11*F11)-( need to subtract "MONTHLY WITHDRAWAL" if "MONTH TO START DRAWING" is greater than the row number the formula will live )

Basically want to plot the value after a months worth of trading according to the variables above.

Thanks for any help in advance

Mark

 

[slinky]

=SUM(B16*J11/(F21*N11))*(B6*F6*N11*B11*F11)-if(row()>MonthToStartDrawing,Monthly Withdrawal,0)

Row() will return the value of the row in which the formula resides. So, unless you're perfectly matched for rows/months, you'll need to do some minor maths against the value returned by Row() to deliver the desired number..

HTH,

slinky

 

[bademployee]

=SUM(B16*J11/(F21*N11))*(B6*F6*N11*B11*F11)-if(row()>MonthToStartDrawing,Monthly Withdrawal,0)

Row() will return the value of the row in which the formula resides. So, unless you're perfectly matched for rows/months, you'll need to do some minor maths against the value returned by Row() to deliver the desired number..

HTH,

slinky

Thanks Slinky