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" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
| 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" <[email protected]> wrote in message
| > news:[email protected]...
| > >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?
| >
| >
| >
|