Excell Tool

  |   |   |   |   |   |
|   |
| | | | | | |
| Data | Is The Cell Blank | | | | |
| 1 | FALSO | =ISBLANK(C4) | | | |
| Hello | FALSO | =ISBLANK(C5) | | | |
|   |VERDADERO | =ISBLANK(C6) | | | |
| 25-dic-98 | FALSO | =ISBLANK(C7) | | | |
| | | | | | |
What Does It Do? |   |   |   |   |   |
This function will determine if there is an entryin a particular cell. | | |
It can be used when a spreadsheet has blank cells which may cause errors, but which |
will be filled later as the data is received by the user. | | | |
Usuallythe function is used in conjunction with the =IF() function which can test the result |
of the =ISBLANK() | | | | | |
| | | | | | |
Syntax |   |   |   |   |   |   |=ISBLANK(CellToTest) | | | | |
| | | | | | |
Formatting |   |   |   |   |   |
Used by itself the result will be shown as TRUE or FALSE. | | |
| | | | | | |
Example |   |   |   |   |  |   |
The following example shows a list of cheques received by a company. | |
When the cheque is cleared the date is entered. | | | |
Until the Cleared date is entered the Cleared columnis blank. | | |
While the Cleared column is blank the cheque will still be Outstanding. | |
When the Cleared date is entered the cheque will be shown as Banked. | |
The =ISBLANK() function isused to determine whether the Cleared column is empty or not. |
| | | | | | |
Cheques Received |   | Date |   | Date |   |   |
Num | From | Received | Amount | Cleared | Banked |Outstanding |
chq1 | ABC Ltd | 01-ene-98 | £100 | 02-ene-98 | 100 | 0 |
chq2 | CJ Design | 01-ene-98 | £200 | 07-ene-98 | 200 | 0 |
chq3 | J Smith | 02-ene-98 | £50 |   | 0 | 50 |
chq4 | Travel Co. |03-ene-98 | £1,000 |   | 0 | 1000 |
chq5 | J Smith | 04-ene-98 | £250 | 06-ene-98 | 250 | 0 |
| | | | | =IF(ISBLANK(F36),0,E36) | |
| | | | | | =IF(ISBLANK(F36),E36,0) |
| |...