Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Password removal? | Excel Discussion (Misc queries) | |||
protection removal | Excel Discussion (Misc queries) | |||
Macro removal | Excel Discussion (Misc queries) | |||
Year row removal | Excel Worksheet Functions | |||
Sheet removal...help please | Excel Discussion (Misc queries) |