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.

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).




"Arla M" wrote in message
...
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.

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.



"Arla M" wrote in message
...
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.

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

From Excel's help, search for Reference Operators

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Arla M" wrote in message
...
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.

This old post may help:

http://tinyurl.com/p4md
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Arla M" wrote in message
...
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.