Posted to microsoft.public.excel.misc

Excel 2003 - SPB Excel 2003 - SPB is offline

external usenet poster

Posts: 26

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find and replace macro strange behaviour	Nicawette	Excel Discussion (Misc queries)	3	June 13th 06 08:49 PM
strange behaviour with matrix formulas	kayard	Excel Worksheet Functions	3	May 16th 06 04:07 PM
Strange behaviour when sorting rows	Paul Moore	Excel Discussion (Misc queries)	1	February 23rd 06 11:23 PM
Strange "FormatCells" behaviour	Mike Hyndman	Excel Worksheet Functions	0	October 23rd 05 05:30 PM
Strange behaviour	Edgar Thoemmes	Excel Worksheet Functions	1	February 8th 05 03:20 PM

All times are GMT +1. The time now is 10:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us