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