Aug 16, 2011 1. Select the entire area that you want to edit within your Excel spreadsheet and select to Copy. Paste this data into an empty Word document. Select Edit then Find. Click the triangle in the bottom left corner, then select the bar in the bottom right corner which says Special and select “Manual line break” 5. May 18, 2012 Where / how do i access the 'Find All' function in Excel 2011 Mac? In Excel for Windows this was easily accessible via the 'find function' and then the 'find all' tab appeared - but in Excel 2011 / msoffice. Frequently Asked Questions Question: In Microsoft Excel, I have the value 'Supermarket' in cell A1 and 100 in cell A2. Objective: If A1 contains 'Super', then I want A3=A2. Otherwise, I want A3=0. 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. Answer: To make sure that do not return any #VALUE! Errors when using the FIND function, you need to also use the in your formula. Let's look at an example. Based on the Excel spreadsheet above, the following FIND examples would return: =IF(ISERROR(FIND('Super',A1,1))=TRUE,0,A2) Result: 100 In this case, cell A1 does contain the value 'Super', so the formula returns the value found in cell A2 which is 100. Based on the Excel spreadsheet above, the following FIND examples would return: =IF(ISERROR(FIND('Super',A1,1))=TRUE,0,A2) Result: 0 In this example, cell A1 does NOT contain the value 'Super', so the formula returns 0. Let's just quickly explain how this formula works. If cell A1 contains 'Super', the FIND function will return the numerical position of the value of 'Super'. Thus, an error will not result (ie. The IsError function evaluates to FALSE) and the formula will return A2. If cell A1 does NOT contain 'Super', the FIND function will return the #VALUE! Error causing the IsError function to evaluate to TRUE and return 0.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |