RUNNING BALANCE NOT SHOWING

[Guest]

I HAVE DATA IN A WORKSHEET. I CAN'T EXPLAIN SO THIS IS WHAT MY WORKSHEET
LOOKS LIKE
A1=374.97 B1=DATE C1=A1/6 D1=DATE E1=A1/6 F1=DATE G1=A1/6
I NEED H1=A1-(C1+E1+G1). THE TRICK IS I DO NOT ENTER ALL THE DATES AT THE
SAME TIME NOR IS IT THE SAME DATES. WHEN I ENTER THE DATE THE VALUE OF C1 E1
AND G1 IS AUTOMATICALLY CALCULATED. SO I NEED H1 TO ABLE TO BE A RUNNING
BALANCE THAT SHOWS THE VALUE OF DATES NOT ENTERED. I HOP THIS IS
UNDERSTANDABLE. I REALLY RALLY HOPE SOMEONE CAN HELP ME. I HAVE BEEN DEALING
WITH THIS PROBLEM FOR THE LAST WEEK OR SO.

THANK YOU

 

[cvolkert]

If I understand you question correctly, wouldn't the following work fo
H1?

=A1/2-(C1+E1+G1)

If B1 is the only item entered, then H1 would equal 2/6 of A1, whic
sounds like what you want. Let me know if I'm off track

- Cha

 

[Guest]

first of all to solve your problem You are going to need to go into the Tools
tab at the top of the worksheet, click on Options, Find the Calculation Tab
and click that. Check the iteration box and in the Maximum Iteration Box
Change it from 100 to 1.
Next Insert a column after the date columns (B1,D1, and F1)
Leave Column A alone and the Date columns Alone Which are now(B1,E1, and H1).
Let Cell C1 =IF(AND(B1<>"",C1=0),A1,C1)
Let Cell D1 =IF(C1<>0,C1/6,0)
Let Cell F1 =IF(AND(E1<>"",F1=0),A1,F1)
Let Cell G1 =IF(E1<>0,F1/6,0)
Let Cell I1 =IF(AND(H1<>"",I1=0),A1,I1)
Let Cell J2 =IF(I1<>0,I1/6,0)

What is happening for example is if there is no date in B1 then C1=0 and
therefore D1=0. When you enter a date into B1 then C1 will take on the value
of A1 and keep that value until B1 is deleted and then reentered. At this
time there is a value in C1 Which will then calculate a value for D1.