Home |
Search |
Today's Posts |
#1
|
|||
|
|||
" " means in IF function
I'm trying to understand what does this mark mean " " in IF function (Logical
test). This has been done in many Excell worksheets but I could not find the author to ask him. If any one can understand the meaning from the examples below, please let me know or provide any helpfull material. =IF(B8-$D$40.05,B8-$D$4,IF(A8="","",0)) =IF(E8="","",IF(ABS(D8-E8)<0.05,0,D8-E8)) Thanks |
#2
|
|||
|
|||
The test A8="" is simply asking whether or not there is anything in that
particular cell. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Sorue" wrote in message ... I'm trying to understand what does this mark mean " " in IF function (Logical test). This has been done in many Excell worksheets but I could not find the author to ask him. If any one can understand the meaning from the examples below, please let me know or provide any helpfull material. =IF(B8-$D$40.05,B8-$D$4,IF(A8="","",0)) =IF(E8="","",IF(ABS(D8-E8)<0.05,0,D8-E8)) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |