Excel Formula to Check If a Cell Contains Text Then Return Value in Another Cell. Here is the Excel formula if cell contains text then return value in another cell. Let us say, we have input data in Cell A1 and We want to Return Value in Another Cell B1. Excel formula for this Criteria is: =IF(A1=My Text To Check, My Text To Return, NOT My. A number of 'Excel if cells contains' formula examples show how to return some value in another column if a target cell contains specific text, any text, any number or any value at all (not empty cell), test multiple criteria with OR as well as AND logic This post will guide you how to return a value if a cell contains a certain number or text string in Excel. How do I check if a Cell contains specific text and then return another specific text in another cell with a formula in Excel IF function will check the logical test is true then result is set, in condition of FALSE will check for another value. This is the method you can follow if you want to put specified text with a number in one cell based on the data in another cell. For more example, click here . If you liked our blogs, share it with your friends on Facebook

- Return a value if a given value exists in a certain range by using a formula. Please apply the following formula to return a value if a given value exists in a certain range in Excel. 1. Select a blank cell, enter formula =VLOOKUP(E2,A2:C8,3, TRUE) into the Formula Bar and then press the Enter key. See screenshot
- Count Cells that contain specific text: Count number of cells if cell contains given text using one formula in Excel. Popular Articles : How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE
- g cells, highlighting, removing or copying entire rows, and more
- Here is a simple formula can help you to return the value in another cell if one cell equals the adjacent one, please do as this: Enter this formula: =IF(A2=B2, C2, ) (A2 and B2 are the two cells that you want to compare, and C2 is the cell value that you want to return) into a blank cell where you want to display the result, and then drag the fill handle down to the cells that you want to.
- In this article we will learn if cell contains word then how to assign value in Microsoft Excel 2010. Let's consider we have a situation where we need to review each cell and check if it contains any text. If yes, we need to return a number in a separate cell, else ignore. We can see how this is done using an example
- This snippet will return TRUE if the the value in B5 contains abc and false if not. The logic of ISNUMBER + SEARCH is explained in detail here. To copy cell the value in B5 when it contains abc, we provide B5 again for the value if true argument. If FALSE, we supply an empty string () which will display as a blank cell on the worksheet

- If Cell contains text from list then return value. Here is the Excel Formula to check if cell contains text from list then return value. We can use COUNTIF and OR function to check the array of values in a Cell and return the given Value. Here is the formula to check the list in range D2:D5 and check in Cell A2 and return value in B2
- Excel Formula Training. Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges
- I want to highlight all cells based on their values. If it contains a value; Only top or bottom ranked We need to set up a formatting formula so that it returns a true or false value. If the value is true, it will apply the desired formatting in excel This has been a guide for Conditional Formatting based on Another Cell Value in Excel
- Whatever the reason, Excel does not recognize such values as numbers. So, if your values do not calculate correctly, the first thing for you to check is whether they are really numbers in terms of Excel, and then convert text to number if needed. Excel ISNUMBER SEARCH formula. Apart from identifying numbers, the Excel ISNUMBER function can also.
- If the data is a number or is a formula that returns a number as output, a value of TRUE is returned by the function â€” the example in row 1 in the image above. If the data is not a number, or the cell is empty, a FALSE value is returned â€” the example in rows 2 in the image above

- The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains a numeric value, or that the result of another function is a number
- Supposing, you have a list of text strings in column A, now, you want to test each cell if it contains one of several values based on another range D2:D6. If it contains any of the specific text in D2:D6, it will display True, otherwise, it will show False as following screenshot shown. This article, I will talk about how to identify a cell if.
- Range: The range in which you want to check if the value exist in range or not. Value: The value that you want to check in the range. Let's see an example: Excel Find Value is in Range Example. For this example, we have below sample data. We need a check-in the cell D2, if the given item in C2 exists in range A2:A9 or say item list. If it's there then, print TRUE else FALSE

The image above shows an array formula in **cell** C3 that checks if **cell** B3 **contains** at least one of the **values** **in** List (E3:E7), it **returns** Yes if any of the **values** are found in column B and **returns** nothing if **cell** **contains** none of the **values**. Example, **cell** B3 **contains** XBF which is found in **cell** E7. **Cell** B4 **contains** text ZDS found in **cell** E6 If O3 has a number (True) then a Yes will be returned. If no then you have a nested if Statement: that if the cell is blank (Nested Logical test) then if true you return a blank and if false you return a No. Hope that makes sense but the formula should work. (Here is the other formula with the nested IF statement as well. Excel if cell contains any text - Best answers; Google sheets copy row to another sheet based on cell value I used this formula to return a Day/Night value based on a time value added in an adjacent cell. When no time value is entered in the C column,. In this example, column D records the date a task was completed. Therefore, if the column contains a date (i.e. is not blank), we can assume the task is complete. The formula in cell E5 uses the IF function to check if D5 is not empty

This can happen if you import data from a database, copy and paste values from the web or a formula that returns numbers that Excel handles as a text string, among other things. For example, cell B10 has a number formatted as a text value and the ISTEXT function incorrectly identifies the number as a text value If a cell contains a word then another cell equals a specific text Here is a simple formula that can help you to quickly check if a cell contains a word, and then put a text in its next cell. Select the cell you want to put the text, and type this formula =IF(ISNUMBER(SEARCH(KTE,A2)),True,) and then drag auto fill handle down to the cells you want to apply this formula Hi i need help with a formula: If this cell contains a date and this cell contains a date then return Yes, if not return No. An Excelchat Expert solved this problem in 23 mins! I am trying to build a formula to do the following: If a cell in column D contains the year 2017, add 52 to the contents of cell C, if column D contains the year 2018, add 104 to cell C The IF-THEN function in Excel is a powerful way to add decision making to your spreadsheets. It tests a condition to see if it's true or false and then carries out a specific set of instructions based on the results. For example, inputting an IF-THEN in Excel, you can test if a specific cell is greater than 900. If it is, you can make the formula return the text PERFECT As you can see, the cell C3 contains January, so the COUNTIF function returns 1 and the SUM also. As this number is different than 0, the IF logical condition is true, so the function returns value_if_true. Therefore, the result in the cell E3 is Yes

* Excel has some very effective functions when it comes to checking if values in one column exist in another column*. One of these functions is MATCH. It returns the row number based on the lookup value from an array. Another such function is VLOOKUP. It returns the value based on a lookup value from a static array I need the formula to look to see if the cell contains say, a 4 and if it does return the value of another field. At the moment I have 6 fields. I put a cross in the two which aren't being used then the formula is pretty much as you suggest, i.e. that if A1 = x then 0 else A2 When writing a formula that references other cells, it can sometimes be useful to check that those cells contain a valid value. In this lesson, we'll look at Excel's ISNUMBER function as a way of doing this. I was recently asked by a reader to provide a formula that would return the result of a calculation if a certain value cell contained a. To solve this problem simply add another number, for example 0. Cell range B3:B6 would then contain 0, 1.33, 1.67, 2. A search value greater than the largest value in the lookup range matches the largest value. Example in above picture, search value is 3 and the returning value is C. Watch video below to see how the LOOKUP function works Hi! I'm trying to return the value from a specific cell. So, if the ranges C2-C60000 contains SUM: then i need the value from the adjacent cell. Example: C50 contains the text Sum: then i need the value from D60 to be retrieved

I need a formula in cell D1 to read . if cell A1 = N/A and B1 = 0 or < 1 then use value from B1 if not N/A and <> 0 or > 1 then use value from C As from the title, I need Excel to auto-populate the B row cells based on the corresponding A row cells content. So if cell A1 contains X or Y or Z, then cell B1 should equal W, or if A1 contains G or H or J, cell B1 should equal W i need help with a formula. column A has my order numbers. If I have duplicate order numbers I need in column B to return value from a plus a -1 , -2 , -3 if there are 3 duplicate orders. if nothing is duplicate just return the same number from A Here is the the Excel formula to check if cell contains specific text then return value. Often, we need to search for a text in a cell or range of cells in the Excel, return if it contains a specific text or string. 1=Character number which you want start you search in within_text from the left

Hi, I want a formula that will return with the value of cell A1 but if cell A1 is blank, then it will take only the value of C1. I tried using this formula - not working right. Thanks ; I am looking for a simple IF statement that will allow me to compare two columns, and if they match, to copy the value from a third column into a new cell. EG: Columns 1 and 3 contain names with column 2 containing value for the column 1 name Figure 2. Sample data to sum cells based on specific text in another cell. Sum Cells in Excel. In summing cells based on the text of other cells, we can use either SUMIF or SUMIFS. SUMIF function in Excel. SUMIF sums the values in a specified range, based on one given criteria. Syntax =SUMIF (range, criteria, [sum_range]) Wher

I need help on my Excel sheet. How can I declare the following IF condition properly? if A1 = n/a then C1 = B1 else if A1 != n/a or has value(int) then C1 = A1*B Excel allows a user to check if a cell contains a number by using the COUNT and FIND functions. This step by step tutorial will assist all levels of Excel users in checking if a cell contains any number. Figure 1. The result of the COUNT and FIND functions. Syntax of the FIND Formula. The generic formula for the FIND function is Alternatively, if the Excel COUNTIF function returns a value of 0, meaning the range does not have cells with a value of greater than 500, the test is FALSE and the formula will return a No value. This tutorial provides one VBA method that can be applied to test if a range contains a value greater than a specific value and return a specified value Check If Cell Contains Text. As mentioned, the IF function always performs an exact match. Therefore we need a different function to determine if the text is in the cell or not. The function we will use is SEARCH. This function will return the position of the text inside the cell, if it is present. =SEARCH(CB2 ,A2

This post will guide you how to lookup a value from a range of cells and return match from adjacent cell in Excel. How do I Vlookup a value and return a value in corresponding, adjacent cell in Excel. Look up Value and Return Adjacent Cell Value Assuming that you have a list of data... read more Â If cell A1 contains any number between 0-7 then A2 returns 1, and if A1 is a number between 8-12 then A2 return 2, and returns 4,5, etc. Please help

Excel IF statement for numbers: greater than, I am trying to return the value of a cell if another cell is greater than an amount I want a formula that check another cell if it contains certain text and just come up with the today's date if find this text HOW TO: If cell contains specific text then return specific text I'm trying to extract a bunch of specific text combinations from cells and present it in a new cell. This formula seems to work for two variables but I can't add any more variables too it Hello - I am working on a spreadsheet for call monitoring for work and need a value to populate into another cell example: If C12 = Yes then D12 = 5 If C12 = No then D12 = -5 IF C12 = N/A then D12 = 5 if this possible? :confused

** I have an excel formula where 3 columns (A,B, C) check values and if true, return OK, I have a fourth column (D) where I want to check if all 3 columns contain OK then return text**. I have tried various formulas and changing OK to blank and using ISBLANK formula but still not working How do i write an If function where if a cell has a certain text in it, it would return a value to onather cell. For instance: If cell B1 has red in it the cell B4 must be 6 If cell B1 has 'blue in it, then cell B4 must be 7 and so on with certain text returning a certain value? Please can you help me

* For example, if you want to check cells A1 and B1, you can use the Exact function in the C1 cell*. When you use this function, Excel will return a value of TRUE if the numbers match, and the value of FALSE if they don't. To locate the Exact function, click on the Formulas tab and then select the Text button. Choose EXACT from the drop-drown menu In this article, we will see how to match two columns in Excel and return a third. In Excel, there are many find and match functions like FIND, MATCH, INDEX, VLOOKUP, HLOOKUP etc. Here in this article, we are going to use some of these. We will see some Excel formula to compare two columns and return a value

How to Check if a string contains one of many texts in Excel: lookup cells if cell contains from given multiple words in Excel using the FIND or SEARCH function. Count Cells that contain specific text: Count number of cells if cell contains given text using one formula in Excel Yes), then put this value in the cell containing the formula. For instance, if any of the cells in range A1:D1 contain the word Yes then put the word Yes in E1, if not, put No. They don't all have to contain the word, just one of them. Your help is appreciated! Thanks, sspurlock1 Hello All, I am trying to have a formula that will check whatever is in a cell, if it is one multiple criteria, then I want it to return something else each time it appears. So if I have 5 cells: Dog Barks Cat Purrs Mouse Squeaks Cat Purrs Dog Barks The left column contains one of several.. You wan to COPY the data or you just want the value to show in that cell? Copying a cell is a VBA thing which is a bit more involved. If you just want to show the value used this: =IF(OR(B15=x,B15=X),C1 5,) If B15 is x or X then show the value in this cell, else show empty Actually Excel is not case sensitive so this would work too

Where value is a reference to the cell you want to test.. For example, to find out if cell A2 is empty, use this formula: =ISBLANK(A2) To check if A2 is not empty, use ISBLANK together with the NOT function, which returns the reversed logical value, i.e. TRUE for non-blanks and FALSE for blanks. =NOT(ISBLANK(A2)) Copy the formulas down to a few more cells and you will get this result True and False Results: In this example if a range contains at least one cell that only has numbers the VBA code will return a value of Contains Number. If a range does not contain any cells that only has numbers the VBA code will return a value of No Number Also, we can use FIND function to replace the SEARCH function in the above IF formula. It will return the same results. Excel IF function with Wildcards text value. If you wan to use wildcard charcter in an IF formula, for example, if any of the values in column B contains *xc*, then return good, others return bad In the previous post, we talked that how to check if cell contains all of values from a list in excel, and this post will guide you how to test a cell if it contains one of several values in a range or a list in excel. How to check that at least one value in a list can be found in another range or a list. check if Cell contains one of many values from rang

This formula uses the **Excel** **IF** function, combined with the less than and equal signs (=), to test if the **value** **in** **cell** C8 is less than or equal to the **value** **in** **cell** C5.**If** the test is TRUE the formula will **return** a No **value**, alternatively if the test is FALSE the formula will **return** a Yes **value** MS Excel 2003: Formula based on whether a cell has a value. This Excel tutorial explains how to create a formula based on whether a cell has a value in Excel 2003 and older versions (with screenshots and step-by-step instructions). Question: I'm trying to create a formula in Microsoft Excel 2003/XP/2000/97 that would do the following I am trying to match account codes in each tab and if those codes match, return a value in the corresponding row. In tab All Locations I need a formula in cell AJ17. I need to match cell A17 with cell O175 in tab Freight Data. If those two cells match then I would like to return the value in cell AK175 in the Freight Data tab

- To test if a cell contains text and return a specified value you can apply Excel or VBA methods. The formula used to test if a cell contains text and return a specified value can be driven by multiple methods with the use of an Excel IF function combined with a COUNTIF, ISNUMBER or ISTEXT function
- Thanks all for the help. I would like a cell D19 to calculate a formula ONLY if cell C19 produces a number, otherwise I would like it to remain clear. I would like cell D19's formula to calculate =C19*D11. How can I do this
- This post will guide you how to sum a given range of cells that if the adjacent cell meet one criteria in Excel. How do I sum All Cells if its adjacent cell is blank or equals to zero or contain a specific text string value with a formula in Excel. How to use SUMIF function to sum cells that if the adjacent cell match one criteria in Excel
- Remember, the IF function in Excel checks whether a condition is met, and returns one value if true and another value if false. 1. The IF function below returns Yes if the input value is equal to an empty string (two double quotes with nothing in between), else it returns No. Note: if the input cell contains a space, it looks blank
- I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) but I keep getting #name errors. If its any help, the cell with the date (I12) is retreiving it via a vlookup function and is not just a date entered manually

The ISNUMBER function returns TRUE if a cell contains a number, and FALSE if not. Explanation: cell A2 contains the word duck, cell A3 contains the word donkey, cell A4 does not contain the word horse and cell A5 contains the word goat. 3. You can also check if a cell contains specific text, without displaying the substring ** The second example will return three because cells B2, C2, and C3 meet the criteria**. If cells contain the specific text then return value in another cell. We can simply modify this example to copy the cell to a different column if the cell contains the specific text. Copy all the data from A1 to C4 to column A Looking for some help to write a macro to do the following: If cell in column F = Chicago then copy formula in cell V1 to Column V in the same row as Chicago and formula in cell W1 to Column W in same row as Chicago and formula in cell X1 to column X in same row as Chicago If cell in..

In case you prefer reading written instruction instead, below is the tutorial. Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it.. But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row (or column) based on the value in one cell Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value in a range of cells.. INDEX function can be used in two ways, INDEX reference and INDEX array The reference form returns the reference to the cell at the intersection of a particular row and column In this VBA Tutorial, you learn how to check if a cell or range is empty.. This VBA Tutorial is accompanied by an Excel workbook containing the data and macros I use in the examples below. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter.. Use the following Table of Contents to navigate to the section you're interested in The Excel ISNUMBER function is categorized under Information functions. It checks if Excel contains a number in a cell or not. It will return TRUE if the value is a number and if not, a FALSE value. For example, if the given value is a text, date, or time, it will return FALSE. As a financial analys Excel formula if cell contains value then multiply. The if function is one of excels logical functions that evaluates a certain condition and returns the value you specify if the condition is true and another value if the condition is false

Sumif function in excel is used if we want to find out the total of values in a cell range when another set of cell range or corresponding array satisfies particular criteria. The function can also be used to add cells that contain specific or partial text. General Syntax for SUMIF function is as follows Excel If Cell Contains Number Watch more videos for more knowledge atom42 excel If Cell Contains Certain Text Then Return Value From Another Cell - Duration: 1:25 SUM the number of cells in the range A4:A10 that contain text + the number of cells that contain number values and if it is > 0 return TRUE, otherwise return FALSE. So, how does this Beauty work? Although this isn't strictly an array formula , in that you don't have to enter it with CTRL+SHIFT+ENTER, the SUMPRODUCT function behaves just like an array formula SUMIF where the criteria is in another cell. You can also use a cell reference as your criteria (i.e. the value in another cell) rather than a number as shown in the examples above. Let's assume that cell D5 contains the value we want to use for our criteria. Here are a couple of examples of formulas using D5

- if B18 reads Buy then use the value of cell B14 if B18 reads Sell then use the value of cell D14 (B18 will alternate between Sell or Buy depending on other factors on my sheet) Hi, I've been trying to get this to work for the past hour and have tried to look for an answer on Google to no avail
- ed by the number in D5) into cell F1. D5 contains a number that aslo changes. If Cell D5 contains 23. I need the contents of Cell A23 into Cell F1. If Cell D5 changes to 77 I need the contents in A77 into Cell F1
- As Scott Heskew said, vlookup is normaly the way to go. But if you'd like another method that might help with certain situations you can also use the if function.
- Getting Data from another worksheet (using INDEX & MATCH) You're seeing a worksheet ('Sheet1') below with some dummy data.In the following image, you are seeing my 'Get' worksheet data. In the B2 cell, you see I have input value 3/2018.All the values from the 'Sheet1' worksheet and under the 3/2018 column are showing under the 'Data' heading
- IF(0,Yes,No) and returns No in cell C3. Array formula. I recommend using the regular formula above, this array formula checks if cell B3 is equal to any of the values in E3:E5, the IF function returns Yes if one of the values is a match and No if none of the values match
- Row number of the cell in reference. type Text value corresponding to the type of data in the cell. Returns b for blank if the cell is empty, l for label if the cell contains a text constant, and v for value if the cell contains anything else. width Returns an array with 2 items

- If cell = date return yes or no. - Forum - Office Software If a cell contains any text then add a value - Forum - Excel
- VLOOKUP finds the value of the F8 cell in the shop_price table array and if it finds then returns the value of the 3 rd column of the same row. 2) Excel VLOOKUP with 2 Tables of Values In this example, you will see how to use two or more table arrays in the Excel VLOOKUP formula
- I want a formula that can search the Value of cell D2 in all the rows of column A and put all the values it finds (full string name) one by one in column E2, E3,E4, so on. In simple words, if we click on find button in excel and give it a value to find, it shows all the related match values available anywhere in the database

- The IF function is also great for comparing numeric values. In the formula below we test if cell B2 contains a number greater than or equal to 75. If it does, then we display the word Pass, and if not the word Fail. =IF(B2>=75,Pass,Fail) The IF function is a lot more than just displaying different text on the result of a test
- How To Highlight Row If Cell Contains Text/Value/Blank In Excel Hi Referring to column H, I have created a number of rules to recognise a word in column H (e.g. nothing), and then colour the whole row (e.g. blue) if that word is present (see below)
- Now let's discuss how to use Excel to reference a cell in another worksheet based on cell value. Reference cells in another Excel worksheet based on cell value. I will show two examples here. Example 1: Select a single cell and refer a whole range of cells. I have two Excel worksheets with names BATBC and GP. You can have many
- If cell A1 contains ABC anywhere within that cell, put Yes in cell B1. Or if cell A1 begins with ABC, put Yes in cell B1 Can I put multiple If/Then/Contains statements in cell B1? Many thanx
- If you are a VBA programmer, you can simply use the function IsNumeric() to check if the cell has a number. However, a cell may have alphanumeric values too and if that is the case, then I want to find and extract only the numbers from string and show it in another cell. Please see the image below
- Let's say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text. You can also use a filter to find text. For more information, see Filter data

In this tutorial, I shall write how to find text in an Excel range and return the reference of the cell that holds the text. I will show several ways to do so. So that your requirement might match with any of the ways. But before going into the main discussion, I want to discuss [ * Returns a specific value if TRUE and another specific value if FALSE*. I want to sum cells that have a C and a decimal number. The cells have other numbers and This article demonstrates several ways to check if a cell contains a value based on a list. The first example [] Nested IF functions

* Find the LOOKUP VALUE Part of the Cell*. Since in this case the start point in each source cell is consistently character 5 and the length of the LOOKUP VALUE will always be 3 characters (such as WHL in cell D8), we can use the MID function to extract the LOOKUP VALUE. The MID function just needs the TEXT, START CHARACTER NUMBER and NUMBER OF CHARACTERS J1 refers to the cell with the value we want to match. E2:E9 refers to the range of values we're searching through. The zero (0) at the end of the formula tells Excel to look for an exact match. If we were matching numbers, we could use 1 to find something less than our query or 2 to find something greater than our query

** Alternatively, if the Excel COUNTIF function returns a value of of 0, meaning the range does not have cells with a value of 500, the test is FALSE and the formula will return a Not in Range value**. This tutorial provides one VBA method that can be applied to test if a range contains a specific value and return a specified value find_text is the text you are searching for.; within_text is the text or cell you are searching in.; start_at is an optional argument that allows you to specify the character number of the within_text at which point to begin the search. By default this is assumed to be 0, meaning it will search the entire string.; A Simple Example. We have a basic spreadsheet created for this example that. First, decide which cell will hold the value of the product you're going to locate. This cell might have some validation based on the list you created so the user gets a list of values to select from, or if you're familiar with using Form Controls, I linked a Drop Down form control to my list of values and did it that way Set Multiple Cells' Values at Once. Instead of referencing a single cell, you can reference a range of cells and change all of the cell values at once: Range(A2:A5).Value = 1 Set Cell Value - Text. In the above examples, we set the cell value equal to a number (1). Instead, you can set the cell value equal to a string of text

* So the formula should return either Â£500 or Â£1000 in the cell but the Â£43000 is made up of two numbers, say for e*.g. Â£42750+350 and if the second number is less than the allowed discount, the actual lower value is returned - in this case the Â£500 or Â£1000 becomes Â£350 If I have a range of cells (A1:A20) I want to write a formula that if any cell contains a number greater than 1 then in cell A21 it returns yes

The ISFORMULA Function is categorized under Excel Information functions. It will test a specified cell to see if it contains a formula. If it does contain a formula, then it will return TRUE. If not, then it will return FALSE. The ISFORMULA function was introduced in MS Excel 2013 Excel VBA check if cell contains date. Date values are numbers, eg today's date as a date value is 42095 (days since 1/1/1900). The way you changed it will return contents of A1 to the string variable sAddr, rather than the address you want to check Excel 2013 - If cell contains word then return value from a list. m) 'change m to the column containing data you want to return 'copy above row to add more columns, but change h and m accordingly endif next x msgbox Complete! Microsoft Excel is waiting for another application to complete an O... Spiceworks Help Desk if it makes a difference whether the cell has text or a number try =IF(ISTEXT(A1),value,) hope (A1) to return TRUE if A1 contains a formula and FALSE if it does not. 0 0. Anonymous. 5 years ago. This Site Might Help You. RE: EXCEL FORMULA - IF any text in one cell THEN insert value? I am looking for a formula in Excel, which. If the result of <formula = a whole number, then <formula2, else <formula3 I have all the formulas working I just don't know how to writeup that first condition, if the resulting value of the formula is a whole number then do this, else that. Pls help, thanks Find and Select the Cells Based on Cell Value and Then Delete the Rows. Excel has a Find and Replace functionality that can be great when you want to find and select cells with a specific value. Once you have selected these cells, you can easily delete the rows