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)-1C$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 in E31 onwards the formula shows # value and F31 onwards it
shows 0 when i plot graph .
If any body did't understand please send me mail i will forward the file to
them
Thanks and Regards
ALL IS WELL

Hi

Write this follwing formula in "B6" =IF(B6<=$C$2,B6/$C$2,0) and copy, your
#Value matter will be resolve.

"vmohan1978" wrote:

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)-1C$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 in E31 onwards the formula shows # value and F31 onwards it
shows 0 when i plot graph .
If any body did't understand please send me mail i will forward the file to
them
Thanks and Regards
ALL IS WELL

Sorry write in D6

"vmohan1978" wrote:

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)-1C$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 in E31 onwards the formula shows # value and F31 onwards it
shows 0 when i plot graph .
If any body did't understand please send me mail i will forward the file to
them
Thanks and Regards
ALL IS WELL

Dear khusro,
It solved the 1 part of my problem i.e "# value " in column "E" .
But i am facing the values in column "F" it shows "0" and in affects my
chart also .



"Khusro" wrote:

Sorry write in D6

"vmohan1978" wrote:

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)-1C$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 in E31 onwards the formula shows # value and F31 onwards it
shows 0 when i plot graph .
If any body did't understand please send me mail i will forward the file to
them
Thanks and Regards
ALL IS WELL

Hi Mohan

Just try these modified codes:

In D6 : IF(B6="","",IF(B6<=$C$2,B6/$C$2,0))

In E6:

IF(D6="","",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: IF(B6="","",E6*$C$3)

The Value in €œF€� is related to €œE€� and "E" is related to €œD€�. The value in D
& E should also be set to €œnull€� to get the €œNull€� value in F

I have tried this, there is no Zero value is appearing in any column after
the selected range

If It doesnt work , just email to me at "


"vmohan1978" wrote:

Dear khusro,
It solved the 1 part of my problem i.e "# value " in column "E" .
But i am facing the values in column "F" it shows "0" and in affects my
chart also .



"Khusro" wrote:

Sorry write in D6

"vmohan1978" wrote:

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)-1C$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 in E31 onwards the formula shows # value and F31 onwards it
shows 0 when i plot graph .
If any body did't understand please send me mail i will forward the file to
them
Thanks and Regards
ALL IS WELL