Ask Your Question

Ottawa Reiver's profile - activity

2014-05-19 21:13:06 +0200 received badge  Notable Question (source)
2014-05-19 21:13:06 +0200 received badge  Famous Question (source)
2013-07-29 21:27:47 +0200 commented answer How can I insert a value in a cell depending on the value of another cell?

Good answer, but my data sample has led you astray. My database also has 2 _and_ 3 character codes, e.g. AFD and ADD. So the substring operation doesn't work. By the way, the colour highlighting of the formula in the cell: what information can I glean from that?

2013-07-29 20:41:24 +0200 received badge  Popular Question (source)
2013-07-28 21:18:52 +0200 asked a question How can I insert a value in a cell depending on the value of another cell?

I have a spreadsheet where column A holds several values ;e.g. MU, AU, EU, MD, AD, ED, CLOSED. "U" stands for "Upstairs", "D" for "Downstairs".

I wish to execute the following pseudocode:

IF cell A'n' = MU or AU or EU THEN write "upstairs" to cell B'n' ELSE IF cell A'n' = MD or AD or ED THEN write "downstairs" to cell B'n' ELSE write "other" to cell B'n' ENDIF ENDIF

I've tried several versions of this code - =IF(D2="DU"or"NU","up","down") - but that gives me Err:508, so I suspect the problem is my ignorance of the proper syntax. Can anyone rectify my ignorance, please? Or point me to a good tutorial, at least.

TIA