Hi Everyone, I'm trying to write an IF statement but not getting the outcome I want. I want to return the words 'Returned last years SCSFEE' in the comment column IF there is a number in the SCS Last Year column. Below is the data before and what I want it to look like after. You will see as there is no number in the first row of data, therefore I don't want any comment to be returned. As the second row of data has 500 in the SCSFEE Last Year, I want to return the statement ' Returned last years SCSFEE' Any help would be greatly appreciated!
BEFORE:
SID COMMENT SCSFEE Last Year
1234
5678 500
AFTER:
SID COMMENT SCSFEE Last Year
1234
5678 Returned last years SCSFEE 500