0
What is the formula for - tell cell B that if cell A empty leave cell B blank and if cell A is greater than 1 make cell B say Hours?
Wiki User
∙ 11y ago
Your formula is not complete as you do not say what happens if the A cell contains 1 and is therefore not bland and not over 1. Using cells A2 and B2 the formula would be put into cell B2 and would be:
=IF(A2="","",IF(A2>1,"Hours",""))
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
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?
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.
What is mean by empty dreams?
Empty dreams mean that you do not experience any dream. You feel empty while sleeping. It is like a blank paper at night.
The cells in a blank spreadsheet are called?
There is no special name for them. They are just blank cells or empty cells, or whatever you want to call them.
How do you create an empty blank in Microsoft Word 2007?
MS home office button; click new (blank document).
What would be another word for empty?
blank, barren, void, vacant
What blank workbook means?
A blank workbook - in relation to computer files - is simply an empty document, spreadsheet or database - that's been newly created. Think of it as an empty piece of paper - ready to be written on.
Synonyms for blank?
unmarked, white, clear, empty, plain, bare, void
What happens to the empty space when a CD-r is burnt?
A blank CD is rather like a blank sheet of paper; so as information is written to it the blank area is replaced with the written information.
What is the opposite of book?
The opposite of book is typically considered to be something like "empty" or "blank," as in a blank page, which is devoid of any text or content.
What is a five letter word besides vacancy that means vacant?
empty, clear, blank
What is likely to cause a page to come out of a laser printer completely blank?
empty buffer
What is the duration of The Empty Star?
The duration of The Empty Star is 1.78 hours.
