Solved

testing for blank cells

Posted on 2011-02-17
2
532 Views
Last Modified: 2012-06-22
Other than writing some VB code.  Is there any way to set a cell blank thru an if statement (ie if a - set value to X if B set value to ???).   I need to later test the value in the cell to if it has an X or is empty.  Unfortunately I have test all the IS functions and none of them can distiquish between " " and a letter.  That is even though the cell looks empty ISBLANK returns FALSE and ISTEXT returns true.  What can I put in the cell that is not visible but is not considered TEXT and or is considered truly blank.
0
Comment
Question by:dma70
2 Comments
 
LVL 3

Accepted Solution

by:
sunezapa earned 125 total points
ID: 34922305
will LEN(<cell>) do it? f.ex. LEN(A2) and eventually combining the statements...
0
 
LVL 1

Author Closing Comment

by:dma70
ID: 34997121
That was easy -- sorry for taking so long to reply -- I was on vacation for the week.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now