In Calc, how do I say that if a cell reference contains certain text, then result with text "X", otherwise, leave it blank?
Example: If cell B2 contains the name "Tom", put an "X" in the current cell.
Here's what I tried that DOESN'T work: In the current cell the formula is in, (cell E2): IF(B2=TOM;"X").
When do I have to use quotation marks? Should TOM be "TOM"?
Is it case sensative, or can I make it give a result whether it is Tom, TOM, or tom?
If I want the result to be an X or a checkmark, do there have to be quotes?
if the cell has any other name, do I have to tell it to leave the cell blank, or will it do so automatically?
How would I write it if I wanted the result to be 'Y' if the referenced cell contains the specific text, or 'N' if it doesn't?
What should I read to find out more about this kind of thing? Logical Functions seems to contain information about numeric data. Text functions seems to contain information about converting text to numbers. Is the information I'm looking for in Boolean arguments? Please help.