If-Then clause using cells in Excel

Question

My situation:

I have some columns in excel containing different values, for each row I want to check column 1,2,3,etc and then I need an if-then clause that works like this:

if (value in colum1=="something")
then 
fill cell x with "something else"

I'm not asking how to do it in details, but if you could tell me what excel functions I should look into to make it possible it'd be great. (I have never worked with excel before and I didnt find much googling)

Answer 1

Place this in the cell which you would like filled:

=IF(A1="Something","Something","NotSomething") 

You can drag this down or across cells as well. The cell value will update itself.

Answer 2

Into Cell X enter the following formula:

=IF(A1="something", "val if true", "val if false")

The general syntax for Excel's IF function is:

=IF([condition], [value if TRUE], [value if FALSE])