Calculation

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

if cell d4 = 64

cell a7 = 8
cell b7 = $D$4-A7

is it possible to change the value of D4 as a running
countdown without a circular reference?
 
Hi
not quite sure what you're trying to achieve?. Could you post an
example (as plain text)
 
Example:
start cell d4

(D4) (E4) (F4) (G4) (H4)
Apples Oranges Pears Cherries Bananas
24 30 15 30 10


(A11) (B11) (C11)
Item #of Remaining

(C8)

=IF(A11="Apples",$D$4-B11,IF
(A11="Oranges",$E$4-B11,IF(A11="Pears",$F$4-B11,IF
(C11="Cherries",$G$4-B11,IF(A11="Bananas",$H$4-B11,"Not
Used")))))

Goal use the 3 colums and keep a running count (deduction)
Hope this makes sense
 
Hi Dan
have a look at Peo's link. You just have an injverse accumulator and
yes you'll need VBA for this
 
Back
Top