IF Formula Help Please

[electricpepper]

Hello bit of a beginner here. Please can anyone tell me if what I am trying to achieve is possible in excel. I feel like everything is if you just know how!

I am creating a spreadsheet where there will moments in column A where there is an entry that reads "ONO". Whenever this happens the cell in column B next to it will read  "For [whatever is in Column A in the row above]". 

I am trying to automate this so that whenever Column A has "ONO", then Column B for that row will autofill. Otherwise it will do nothing and entries will be manual. 

My attempt was =IF(A2="ONO","For""A1","")

This comes back as wrong. Please can anyone help?

[#2 · Accepted solution]

@electricpepper 

I guess:

=IF(A2="ONO","For "&A1,"")

[#3]

@Detlef_Lewin Ah... That one little "&" that was missing.... I have a lot to learn.... Thank you so much, I really appreciate the help. My life just got a little easier!