automatic calculation

[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.

 

[Claus Busch]

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.

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


Regards
Claus Busch

 

[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.

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.

 

[Claus Busch]

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?

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