I'm unable to use the FIND function because if cell A1 does not contain 'Super', the FIND function returns the #VALUE! error which does not let me sum column A.Īnswer: To make sure that do not return any #VALUE! errors when using the FIND function, you need to also use the ISERROR function in your formula.īased on the Excel spreadsheet above, the following FIND examples would return: =IF(ISERROR(FIND('Super',A1,1))=TRUE,0,A2) Objective: If A1 contains 'Super', then I want A3=A2. Question: In Microsoft Excel, I have the value 'Supermarket' in cell A1 and 100 in cell A2.
