Neal;160745 Wrote:
=SUM(B3*(C3+D3(-(IF(AND(E3=0,G3<0),E3,0))),(IF(AND(G3=0,I3<0),(+ F3-G3),0)),(IF(AND(I3=0,K<0),(+F3+H3-I3),0)),(IF(K3=0),(+F3+H3+J3-K3),0)))

Well, there's a TYPO in there, ... *(IF(AND(I3=0,K_3_<0)*.....

Neal;160779 Wrote:
If it were mid-year, the 3rd and 4th Quarter cells would be blank and
the formula would be:
* B3*(C3+D3+F3-G3)

* If it were the end of the year it would be:
*B3*(C3+D3+F3+H3+J3-K3)*

No, the second formula would be the one you use all year long. If the
later quarters are empty, they add zero, no harm done, and it always
reflects the current status of things based on the numbers all across
row3.

Fred is right.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44683