If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#3
|
|||
|
|||
It is asking if the cell is empty, if so return an empty cell otherwise
return 0. -- Ken Russell Remove yourhat to reply by e-mail .. "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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
loop for replace function | luzippu | Running & Setting Up Queries | 2 | March 24th, 2005 10:13 AM |
Hi - RPC over HTTP problem: | MarkInIreland | Installation & Setup | 3 | March 13th, 2005 02:29 PM |
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Elijah-Dadda | Worksheet Functions | 0 | March 5th, 2005 03:31 AM |
UK postcode issue | Lapchien | Running & Setting Up Queries | 6 | June 11th, 2004 09:06 PM |
Modify "Remove Dots" function | Tom Bock | Worksheet Functions | 3 | March 15th, 2004 09:28 PM |