if () formular disappearing when values change
 

Hi guys
I have included the previous thread
all is good with the formular
a1=if(b1=1,"Yes","No")
b1=1

when I change the value in B1 to 0
the contents (using edit F2) become
text "No"

any ideas in settings etc

SPB
---------------------------------------------------
Thanks for the reply, but the formular is missing when you look into/edit the
cell

"Otto Moehrbach" wrote:

That is the normal and intended behavior. The formula is placed in n20 and
the formula says, in English, if the entry in o20 is a 1, then display "yes"
in the cell in which the formula is located, which is n20 in your case. If
o20 is not a 1, display "No". The formula has not gone anywhere, it is
still in the cell. What is in the cell and what is displayed in the cell
are not necessarily the same thing. As in your case. HTH Otto
"Excel 2003 - SPB" wrote in message
...
I have typed the following in
n20 =if(o20=1,"yes","No")
when I type 1 into o20
n20 becomes Yes
the formula disappears it is not the only cell to have this problem
any suggestions?

if () formular disappearing when values change
 

Please stay in you original thread, where your question has been answered already. If you're not satisfied withe the answer,
respond in that same group please.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Excel 2003 - SPB" wrote in message
...
| Hi guys
| I have included the previous thread
| all is good with the formular
| a1=if(b1=1,"Yes","No")
| b1=1
|
| when I change the value in B1 to 0
| the contents (using edit F2) become
| text "No"
|
| any ideas in settings etc
|
| SPB
| ---------------------------------------------------
| Thanks for the reply, but the formular is missing when you look into/edit the
| cell
|
| "Otto Moehrbach" wrote:
|
| That is the normal and intended behavior. The formula is placed in n20 and
| the formula says, in English, if the entry in o20 is a 1, then display "yes"
| in the cell in which the formula is located, which is n20 in your case. If
| o20 is not a 1, display "No". The formula has not gone anywhere, it is
| still in the cell. What is in the cell and what is displayed in the cell
| are not necessarily the same thing. As in your case. HTH Otto
| "Excel 2003 - SPB" wrote in message
| ...
| I have typed the following in
| n20 =if(o20=1,"yes","No")
| when I type 1 into o20
| n20 becomes Yes
| the formula disappears it is not the only cell to have this problem
| any suggestions?
|
|
|
|