G
Guest
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.
empty space is used in formulas and what it means? Thank you.
D
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).
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).
D
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.
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.
R
Rob van Gelder
An empty space between range references is an Intersect operator.
eg. =A1
1 B1:B3 returns the same number as =B1
From Excel's help, search for Reference Operators
eg. =A1
1 B1:B3 returns the same number as =B1From Excel's help, search for Reference Operators
R