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?

​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?  Read More

​