displaying results

[Guest]

Something strange is happening. I have formulas in three different cells in order to calculate the number of days an invoice has been past due. If it's past due 30 or less days it goes in one column and 30-60 another and > 60 another.

=IF(AND($B$1-$C5<=30,$K5=0),$F5,0) this calculates the less than 30 days, cell b1 is today's date and k5 states if it has been paid or not. f5 contains the invoice amount. oh and c5 is the invoice dat

My problem is that if I go back and put something on cell k5 to state it has been paid then the amount remains in the column and I want it to give me a 0. It does do it but I have to physically go and press the fx button in order to calculate and give me the result of the formula that i have in it
Can anyone help me please? I don't want to have to go to each cell and calculate each formula everytime I make a change

 

[John Wilson]

Kenya,

Do you have the "Automatic" checkbox checked in
Tools/Options/Calculation?

John

Something strange is happening. I have formulas in three different cells

in order to calculate the number of days an invoice has been past due. If
it's past due 30 or less days it goes in one column and 30-60 another and >
60 another.

=IF(AND($B$1-$C5<=30,$K5=0),$F5,0) this calculates the less than 30 days,

cell b1 is today's date and k5 states if it has been paid or not. f5
contains the invoice amount. oh and c5 is the invoice date

My problem is that if I go back and put something on cell k5 to state it

has been paid then the amount remains in the column and I want it to give me
a 0. It does do it but I have to physically go and press the fx button in
order to calculate and give me the result of the formula that i have in it.

Can anyone help me please? I don't want to have to go to each cell and

calculate each formula everytime I make a change.