Thread: Strange if(***) behaviour?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel 2003 - SPB Excel 2003 - SPB is offline
external usenet poster
  
Posts: 26
Default Strange if(***) behaviour?
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?
Reply With QuoteReply With Quote