automatic calculation

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

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top