you may have explain your situation, but I still don't follow what you want to
do. Maybe it would be easiler to post your sample and expected result
Alternatively, post ypur sample at a host free site like savefile
and tell us the link to it
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Bowmanator" wrote:

new at this and everything i know i learned from here and i Hope you guys can
help me with this one.
I'm working on this spread sheet below, i know what i want it to do just
hard to explain. it's performing somewhat like i want but i needs to be
tweeked.

column E and F seems to be doing what it suppose to. E seems to be the
problem.

in column D i'm using =IF(C20,F1,"") and that seems to work if there's an
entry in column A, but if A2 is blank i need D2 to be blank and F2 is the
result of C2-F1. now if you look at row 3 it's doing exacly like it should,
D3 is showing that it took F3 + E7 to equal C3, and F3 is the result of A3-E3.


the formulas i'm using are
column D =IF(C20,F1,"") and so on down th column
column E =SUM(IF(C50,G5-H5))
column F =SUM(IF(C50,(J4+C5-G5),IF(G50,(J4-G5))))

sorry for be so long winded, didn't know any other way to explain it.
now my brain hurts.

thanks
Dave

A B C D
E F
new amount production amount used amount
remanning
batch produced in lbs. from previous used
from batch
batch
new batch
1 127,423 1,500 54,000
54,000 73,423
2 1,200 43,000 73,423
30.223
3 149,481 1,000 36,000 30,223
5,777 143,704
4 1,350 48,600 143,704
95,104
5 2,000 72,000 95,104
23,104
6 136,364 1,525 54,900 23,104
31,796 104,568