Should be an easy one.
Is there any command usable in an IF statement that checks to see if a cell has a value or text in it? Like IF(A1="text or number", YES, NO). Tried both text and value but those are converters.
If not then I guess I'll do things the hard way and make a ton of IF statements within each other.
Hi there,
You can use the ISTEXT (the cell contains a text value) or ISNUMBER (the cell contains a numeric value) functions. This returns a boolean TRUE or FALSE. So, if your data is in column A, just do =ISTEXT(A1) (or =ISNUMBER(A1) dependent on which you prefer then drag down.
If you want something more than TRUE and FALSE - e.g. "Yes","No" - then do: =IF(ISTEXT(A1),"Yes","No").
HTH,
SamuelT
Sounds like you just want to see if it's not blank... so either
=IF(A1<>"","Yes","No")
or
=IF(COUNTBLANK(A1),"No","Yes")
(note COUNTA unlike COUNTBLANK would interpret a formula null as non-blank)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Agreed - I misread the post!Originally Posted by DonkeyOte
If you want some VBA to play with :
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks