Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:Tagif then help This is the formula I am using, but after I click enter it stays empty. =IF(A2<=500,"1","0") In both tabs of the new Excel file, fill in the new ‘Comments’ column with the following: If the ‘Org ID’ field is ≤500, fill in the corresponding ‘Comments’ field with “1” If the ‘Org ID’ field is >500, fill in the corresponding ‘Comments’ field with “0”
