| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF statement to check cell contents
I am trying to check the contents of a cell that displays text, but there is
a formula in that cell. When I look for the text in the cell, I get an error, since I assume that it is really checking the formula and not the text name that is displayed. How can I check the text and not the actual formula in the cell? THanks, Lance |
|
#2
|
|||
|
|||
|
It will check for the text but you need to encapsulate it in ""
example =if(A2="March",3,"no month entered") Greetings from New Zealand Bill K "Lance Gray" wrote in message ... I am trying to check the contents of a cell that displays text, but there is a formula in that cell. When I look for the text in the cell, I get an error, since I assume that it is really checking the formula and not the text name that is displayed. How can I check the text and not the actual formula in the cell? THanks, Lance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| "Check Marking" a cell | Excel Discussion (Misc queries) | |||
| How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
| Insert new row as cell contents change | Excel Discussion (Misc queries) | |||
| VBA Command to Look at cell in an If statement | New Users to Excel | |||
Linear Mode
