Off TopicAre you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.
(
rob, Sun 1 Apr 2001, 1:00)
« Go Back | See The Full Thread
Well I thought it was a simple thing!Basically I have a column of 0's and I just want them to change to a 1 if I write text in the cell next to them. I thought it was something like =if(a2=text,0,1) but obviously not.
Excel makes me feel really stupid as I can't retain formulae :(
(
TGB checking Off Topic is still shit at, Mon 2 Mar 2009, 12:04,
Reply)
« Go Back | See The Full Thread