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 |
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 |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com