![]() In this example, cell A1 does NOT contain the value "Super", so the formula returns 0. In this case, cell A1 does contain the value "Super", so the formula returns the value found in cell A2 which is 100. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |