I need help on which formula to use for the following query!
If I have some short messages in cell number 1 and 3 of column A and cell number 2 and 4 are empty. I need a formula which gives a result as 1 when there is a message and 0 for no text message in column B. Thanks in advance.
Eg
A B
Hello 1
0
Nice 1
0
Last edited by shuresh; 06-11-2009 at 06:47 PM. Reason: Not complying with the forum rules
Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
Entia non sunt multiplicanda sine necessitate
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Moved to Functions Forum
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks