0
In Microsoft Excel you want to use this if statement ife8yescorrectfalse how do you make the if statement cell blank if there is no text in cell e8?
Wiki User
∙ 14y ago
If the word Yes is in E8, the following formula will put Correct in the cell that the formula is in, or else leave it blank, which is done by have a two sets of double quotes with no gap between them after the final comma.
=IF(E8="Yes","Correct","")
You can exchange the Yes with whatever you are testing for and the Correct with whatever you want to put in the cell.
Another thing you can do is use the IsBlank function to test if the cell is empty. If it is empty it will leave the cell with the formula blank or will put the word Correct in, no matter what is in the cell E8 if it is not blank. That may not be exactly what you want to do, but this would be the formula.
=IF(IsBlank(E8),"","Correct")
If you want to allow numbers to be in the cell, but no text you could use the IsText function:
=IF(Not(IsText(E8)),"","Correct")
Probably the first formula or a slight variation of it is what you are looking for.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
When you open a Microsoft Excel workbook you will see a document or a blank sheet of paper?
What you will see is a blank worksheet, which is a spreadsheet document in Excel.
Do statistical functions ignore blank cells in Microsoft Excel?
Yes it does.
How many worksheets does Excel have when it opens a new workbook?
In Microsoft Excel, a new workbook will normally have three worksheets.
What can you see when you open Microsoft Excel?
You will see a blank worksheet entitled Book1 when you open Excel. Depending on the version, you will see other things such as a ribbon or menus.
When i open Excel it is blank?
When you open Excel, it is supposed to be blank. That way, it will be ready for you to create a worksheet.
What appears when you start Excel?
A blank worksheet.
What types of blank certificates does Microsoft offer for free?
Microsoft offers quite a number of blank certificates for free. However, most of the certificates offered from Microsoft could be described as simple.
What is a blank statement?
A blank statement is a statement that lacks specific information or content, leaving it open to interpretation or completion by the reader or listener. It may be intentionally left blank for later input or completion, or it may be unintentional due to missing information.
What cell in excel with a numerical value of zero?
Blank Cell
What is the new of a new worksheet in Excel?
Create a blank worksheet.
In excel what contains the numerical value of zero?
Blank Cell.
How many blank worksheets are shown when a new workbook is created in excel?
Three blank worksheets.
