Empty space in formulas.

[Arla M]

Can someone explain to me or point me to a good site that explains how an
empty space is used in formulas and what it means? Thank you.

 

[Dave R.]

Can you give an example? Most empty spaces of use in formulas have quotes
around them, like
=IF(A1="","none",C1)

Apparently you can get away with formulas like:

=SUM( B1:B15 )

but the first paren must be right up against the function (sum).

 

[Dave R.]

And to explain the "" or " " in a formula, they refer to either 0 length
text strings ("") or actual spaces (" ").

They can be used to locate the position of spaces in text strings, which can
be useful in separating one string into two.

 

[Rob van Gelder]

An empty space between range references is an Intersect operator.
eg. =A11 B1:B3 returns the same number as =B1

From Excel's help, search for Reference Operators

 

[Ragdyer]

This old post may help:

http://tinyurl.com/p4md