ISBLANK ()
This function determines if there is an entry in particular cell. But usually this function used with IF function which can test the result of the ISBLANK() function.
This functions ensures if there is any blank cell, this will not give any error but filled with zero or any other value entered. And after filling data in blank cell, shows the result.
Best view in desktop mode.
|
A |
B |
C |
D |
|
|
1 |
Values |
If The Cell Blank |
Target Result |
|
|
2 |
1 |
FALSE |
=ISBLANK(A2) |
|
|
3 |
Hello |
FALSE |
=ISBLANK(A3) |
|
|
4 |
TRUE |
=ISBLANK(A4) |
||
|
5 |
25-Dec-98 |
FALSE |
=ISBLANK(A5) |
|
|
6 |
Syntax
=IFBLANK (cell)
Formatting
No special formatting is needed. Used by itself the result will be shown as TRUE or FALSE.
Example
Here is a check clearance check spreadsheet. When the check is cleared the date is entered that shows amount deposited & no overdue in next cell i.e. blank.
If the cleared date is blank, the check will show outstanding.
Here ISBLANK function check the condition if the cell is blank and give its result to IF function.
|
A |
B |
C |
D |
E |
F |
G |
H |
|
|
9 |
Cheques Details |
Date |
Clearance Details |
|||||
|
10 |
Number |
From |
Amount |
Received |
Cleared |
Deposited |
Outstanding |
|
|
11 |
458623 |
John Wick |
रु 200 |
1-Oct-20 |
3-Oct-20 |
रु 200 |
||
|
12 |
584585 |
Fisc Corp |
रु 500 |
2-Oct-20 |
5-Oct-20 |
रु 500 |
||
|
13 |
456854 |
Matt Lopaz |
रु 30 |
3-Oct-20 |
रु 30 |
|||
|
14 |
754868 |
Nitin Kumar |
रु 2,500 |
4-Oct-20 |
7-Oct-20 |
रु 2,500 |
||
|
15 |
546852 |
Mohd Shareef |
रु 1,000 |
5-Oct-20 |
रु 1,000 |
|||
|
16 |
=IF(ISBLANK(E11),"",C11) |
=IF(ISBLANK(E11),C11,"") |
||||||
|
17 |
=IF(ISBLANK(E12),"",C12) |
=IF(ISBLANK(E12),C12,"") |
||||||
|
18 |
=IF(ISBLANK(E13),"",C13) |
=IF(ISBLANK(E13),C13,"") |
||||||
|
19 |
=IF(ISBLANK(E14),"",C14) |
=IF(ISBLANK(E14),C14,"") |
||||||
|
20 |
=IF(ISBLANK(E15),"",C15) |
=IF(ISBLANK(E15),C15,"") |
||||||
|
21 |
||||||||
|
22 |
Totals |
रु 3,200 |
रु 1,030 |
|||||
|
23 |
||||||||
No comments:
Post a Comment