Running total calculation projection

M

Melh

Hi
I can't figure this one out, please help. I have built a financial data sheet that creates a projection of what the total will be which works ok, but a new entry is added each day that changes it. If the next day is blank is continues to reduce the formula out to the end of the month. I believe a vlookup formula will work but , what do I use for it not to continue to calculate until the blanks are filled?
=m6/a6*A4
where m6 is totals sale
A6 is the number of workdate
a4 is total number of workdays in the mont

Thanks
 
F

Frank Kabel

Hi
not really sure what you're trying to do b ut maybe the following is
what you're looking for
=IF(M6<>"",M6/A6*A4,"")
 
Top