V
vmohan1978
A B c
1 Project Start Date Jan-10
2 Project Duration 25
3 Project Cost 1000000
In B6 i wriiten formula IF(ROWS($1:2)-1>C$2,"",ROWS($1:2)-1)
In D6 i written formula IF(B6="","",B6/$C$2)
in E6 i writtend formula
IF(D6<=33.33%,(($I$1*D6^2)*100),IF(D6<=66.67%,($I$2*D6+$I$3),IF(D6>=66.67%,($I$4+$I$5*D6+$I$6*D6^2)*100,"")))
In F6 i have written IF(B6="","",E6*$C$3)
the formula in B6 is copied down till B40 so that when i change number in
c2 it changes automatically .
My problem is from F31 onwards it shows as blank but computer reads as 0
when it plots the chart.
If any body did't understand please send me mail i will forward the file to
them
1 Project Start Date Jan-10
2 Project Duration 25
3 Project Cost 1000000
In B6 i wriiten formula IF(ROWS($1:2)-1>C$2,"",ROWS($1:2)-1)
In D6 i written formula IF(B6="","",B6/$C$2)
in E6 i writtend formula
IF(D6<=33.33%,(($I$1*D6^2)*100),IF(D6<=66.67%,($I$2*D6+$I$3),IF(D6>=66.67%,($I$4+$I$5*D6+$I$6*D6^2)*100,"")))
In F6 i have written IF(B6="","",E6*$C$3)
the formula in B6 is copied down till B40 so that when i change number in
c2 it changes automatically .
My problem is from F31 onwards it shows as blank but computer reads as 0
when it plots the chart.
If any body did't understand please send me mail i will forward the file to
them