Hi I wonder if anyone can help. In column B I have several different letters (y, l, s) I wan to do is in the cell next the letter put a word, for example when there is a y in the cell, I want the cell next to it to say present. How can I do this?
Hi I wonder if anyone can help. In column B I have several different letters (y, l, s) I wan to do is in the cell next the letter put a word, for example when there is a y in the cell, I want the cell next to it to say present. How can I do this?
Try... just change what you want it to say for L & S
=IF(A1="Y","Present",IF(A1="L","Test",IF(A1="S","Test II","")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks