| 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 |
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.