dataspot21
New Member
- Joined
- Nov 13, 2014
- Messages
- 5
I am trying to enter formulas I have used for years, but I continue to get the general error message:
The formula you typed contains an error.
For information about fixing common formula problems, click Help
To get assistance in entering a function, clcik Function Wizard (Formulas tab, Function Library group)
If you are not trying to enter a formula, avoid using an equal sign (=), or preced it with a single quoatation mark (')
I get this message when trying to enter any of these formulas: Left, Right, mid, Find, If. However, I can enter the Upper formula, referencing cell a2, which I am referencing when I try to use the other formulas.
Column a, containing full name data (LN, FN) is formatted as General. Column b, where I am entering the formulas, is formatted as General. In my File Options, automatic calculation is checked.
I would appreciate suggestions for resolution. FYI - I am using Excel 2010 on Windows 8.1 laptop.
Thank you
The formula you typed contains an error.
For information about fixing common formula problems, click Help
To get assistance in entering a function, clcik Function Wizard (Formulas tab, Function Library group)
If you are not trying to enter a formula, avoid using an equal sign (=), or preced it with a single quoatation mark (')
I get this message when trying to enter any of these formulas: Left, Right, mid, Find, If. However, I can enter the Upper formula, referencing cell a2, which I am referencing when I try to use the other formulas.
Column a, containing full name data (LN, FN) is formatted as General. Column b, where I am entering the formulas, is formatted as General. In my File Options, automatic calculation is checked.
I would appreciate suggestions for resolution. FYI - I am using Excel 2010 on Windows 8.1 laptop.
Thank you
