automatic calculation

  • Thread starter Thread starter 3Suk
  • Start date Start date
3

3Suk

dear all,
in excel option, formula, the calculation has already been set to "automatic". But some formula doesn't calculate autmatically, pls advise why?

For example, =IF(A1="",B1="","N")
when I put an "A" in A1, then B1 will update to "N" auotmatically
when I delete the "A", B1 is still = "N" until I press an enter in B1 cell.


Thanks,
Patrick.
 
Hi Patrick,

Am Tue, 15 Jan 2013 23:49:23 -0800 (PST) schrieb 3Suk:
For example, =IF(A1="",B1="","N")
when I put an "A" in A1, then B1 will update to "N" auotmatically
when I delete the "A", B1 is still = "N" until I press an enter in B1 cell.
Click to expand...

you have a syntax error
Formula in B1:
=IF(A1="","","N")


Regards
Claus Busch
 
dear all,

in excel option, formula, the calculation has already been set to "automatic". But some formula doesn't calculate autmatically, pls advise why?



For example, =IF(A1="",B1="","N")

when I put an "A" in A1, then B1 will update to "N" auotmatically

when I delete the "A", B1 is still = "N" until I press an enter in B1 cell.





Thanks,

Patrick.
Click to expand...

Claus,
it's me again. Thanks for your quick reply. Is it called "circular reference warning"? if yes, if there are a lot of formulas in the worksheet, how can I trace the problem cell?

Patrick.
 
Hi Patrick,

Am Wed, 16 Jan 2013 00:15:08 -0800 (PST) schrieb 3Suk:
it's me again. Thanks for your quick reply. Is it called "circular reference warning"? if yes, if there are a lot of formulas in the worksheet, how can I trace the problem cell?
Click to expand...

a formula can't fill another cell. If you want to display a "N" in B1
you have to put the formula in B1 (Without B1=""):
IF(A1="";"";"N")


Regards
Claus Busch
 
Back
Top