software

I am trying to write an IF statement in a cell for a calculation based
on whether a cell is blank or not. This is what I have started with
but I know it isn't correct
=IF(ISBLANK(D7),(D6-D2))amp;IF(ISBLANK(D6),(D5-D2))

Example:

Cell
Weekly Standard 10,000 (D2)
Week 1 Input 2,000 (D3)
Week 2 Input 13,500 (D4)
Week 3 Input (D5)
Week 4 Input (D6)
Week 5 Input (D7)

Variance Amount (D9) (i.e D4-D2)

(This field should be based on the last entry made minus the weekly
standard.
The formula needs to start with Week #5 then 4 then 3 then 2. Any help
with this would be greatly appreciated especially with my limited
knowledge.Giving overworked IF a rest, try
=D2-INDIRECT(quot;Dquot;amp;COUNT(D37) 2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;alaxmenquot; gt; wrote in message oups.com...
gt;I am trying to write an IF statement in a cell for a calculation based
gt; on whether a cell is blank or not. This is what I have started with
gt; but I know it isn't correct
gt; =IF(ISBLANK(D7),(D6-D2))amp;IF(ISBLANK(D6),(D5-D2))
gt;
gt; Example:
gt;
gt; Cell
gt; Weekly Standard 10,000 (D2)
gt; Week 1 Input 2,000 (D3)
gt; Week 2 Input 13,500 (D4)
gt; Week 3 Input (D5)
gt; Week 4 Input (D6)
gt; Week 5 Input (D7)
gt;
gt; Variance Amount (D9) (i.e D4-D2)
gt;
gt; (This field should be based on the last entry made minus the weekly
gt; standard.
gt; The formula needs to start with Week #5 then 4 then 3 then 2. Any help
gt; with this would be greatly appreciated especially with my limited
gt; knowledge.
gt;
As long as there are no gaps in the data, you could use

=OFFSET(D2,COUNTA(D27)-1,0)-D2

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;alaxmenquot; gt; wrote in message oups.com...
gt; I am trying to write an IF statement in a cell for a calculation based
gt; on whether a cell is blank or not. This is what I have started with
gt; but I know it isn't correct
gt; =IF(ISBLANK(D7),(D6-D2))amp;IF(ISBLANK(D6),(D5-D2))
gt;
gt; Example:
gt;
gt; Cell
gt; Weekly Standard 10,000 (D2)
gt; Week 1 Input 2,000 (D3)
gt; Week 2 Input 13,500 (D4)
gt; Week 3 Input (D5)
gt; Week 4 Input (D6)
gt; Week 5 Input (D7)
gt;
gt; Variance Amount (D9) (i.e D4-D2)
gt;
gt; (This field should be based on the last entry made minus the weekly
gt; standard.
gt; The formula needs to start with Week #5 then 4 then 3 then 2. Any help
gt; with this would be greatly appreciated especially with my limited
gt; knowledge.
gt;
Gentlemen, I tried both suggestions with equal results. Thanks for you
help in this matter for truly I could not done it with out you.
Thanks....