- 1). Type the basic if formula, leaving off the period at the end: =IF(cell,true,false).
- 2). Replace "cell" in the formula with the cell in question: =IF(A2,true,false).
- 3). Add the isblank function directly before the cell reference: =IF(ISBLANK(A2),true,false).
- 4). Replace "true" and "false" with what Excel should place in the cell if A2 is blank (that is, if the condition of A2 being blank is true) and what Excel should place in the cell if A2 is not blank (that is, if the condition is false), respectively. Enter values, such as "5" and "10," additional functions, such as "SUM(B1:B10)," or text enclosed in quotation marks, such as "Blank" or "Not blank." Your completed formula might read: =IF(ISBLANK(A2),"Blank","Not blank") or =IF(ISBLANK(A2), SUM(B1:B10), A2). The latter displays the value of cell A2 if A2 isn't blank and sums cells B1 through B10 if it is.
- Advertisement -
- Advertisement -
EDITOR PICKS & Articles
- Honest Marketing Techniques - Products You Should Stay Away From - Part 1
- The Official Infrastructure Along With The Best Office Chairs
- Sales Lead Generation and The "Out of Jurisdiction" Paradox
- Unsuccessful With Your Business Proposal? You Can Still Get Something From Losing
- Knowing Your Market - With All the Bad Stuff in the News, When is Profiling a Good Thing?
- How to Find Keywords
- Online Paid Surveys - Can it Fit the Teens of Today?
- Free Contest Concepts That will Enhance Your Publicity
- Affiliate Marketing Is A Profit-sharing Business Venture......................
- DreamHost Promo Code - How to Save Maximum?
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
"Technology" Categories
Stay With Us
"Technology" MOST POPULAR
"Technology" Lastest Articles