LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 38
Default Removal of Zero

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password removal? Bob Newman Excel Discussion (Misc queries) 5 January 28th 09 12:28 AM
protection removal meduk Excel Discussion (Misc queries) 3 April 19th 08 09:28 PM
Macro removal Mike Milmoe Excel Discussion (Misc queries) 2 February 16th 06 08:19 PM
Year row removal smurray444 Excel Worksheet Functions 0 December 5th 05 10:48 PM
Sheet removal...help please Terry Excel Discussion (Misc queries) 2 July 19th 05 11:12 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"