cell references

[terimusic]

Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators, is that true?

 

[Andrew Poulsom]

1. If you enter cell references in lower case Excel converts them to upper case.

2. Excel ignores spaces in formulas.

3. Enter this formula and see what happens:

=a1 + b1

 

[hedrijw]

In Excel 2000 you can enter cell references in lower case, but they'll get changed to upper. You can insert spaces after arithmetic operations 1.e:

=COUNT(A1:A4000) + H3

 

[Juan Pablo González]

One way to enter them in lower case (Just to prove it can be done :wink: )

=INDIRECT("a1")