Forum Discussion
Solved
THERE'S A PROBLEM WITH THIS FORMULA
Hi, I'm trying to write this formula +1/17.5, when the cell is in "general" format, there's no problem, but when the format is "number" an error pops saying "There is a problem with this formula"...
Yes, as everyone mentioned here, best to start formula with =. Most reliable.
However, from time to time I prefer to use Numpad only, thus formulae start with +. Especially if we use Excel as calculator. No problems on Excel for Web. On Excel desktop, as mentioned,
In general that's 30-years old question, lot of answers could be found.
It's an old Lotus 123 quirk. There is an option to have Excel evaluate it (It's tucked away in advanced options but not worth the trouble because the setting is done sheet-by-sheet.) if you provide "+" instead of "=". It will actually correct the formula for you.
It's best to start formulas with =.