Prev: default conformation page
Next: Direct Interactive Button to Multiple Destinations
From: vmohan1978 on 25 Jan 2010 06:24
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

From: Ronx on 25 Jan 2010 06:27
This is an Excel problem, not FrontPage. FrontPage is for web pages, not
spreadsheets.

--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



"vmohan1978" <vmohan1978(a)discussions.microsoft.com> wrote in message
news:DB114233-7DE6-4A2E-AF46-001EC59EDF4C(a)microsoft.com...
> 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
>
 | 
Pages: 1
Prev: default conformation page
Next: Direct Interactive Button to Multiple Destinations