Forum Discussion

electricpepper's avatar
electricpepper
Copper Contributor
Sep 15, 2024
Solved

IF Formula Help Please

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 Replies

Resources