" " means in IF function

[Sorue]

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$4>0.05,B8-$D$4,IF(A8="","",0))
=IF(E8="","",IF(ABS(D8-E8)<0.05,0,D8-E8))

Thanks

[Andy Wiggins]

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" <[email protected]> wrote in message
news:[email protected]...
> 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$4>0.05,B8-$D$4,IF(A8="","",0))
> =IF(E8="","",IF(ABS(D8-E8)<0.05,0,D8-E8))
>
> Thanks

[Ken Russell]

It is asking if the cell is empty, if so return an empty cell otherwise
return 0.

--
Ken Russell

[email protected]
Remove yourhat to reply by e-mail
..

"Sorue" <[email protected]> wrote in message
news:[email protected]...
> 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$4>0.05,B8-$D$4,IF(A8="","",0))
> =IF(E8="","",IF(ABS(D8-E8)<0.05,0,D8-E8))
>
> Thanks