10.20 How do I protect myself in Excel against "unary" minus type bugs in my formulas?
Description
This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.
10.20 How do I protect myself in Excel against "unary" minus type bugs in my formulas?
You can use the AutoCorrect feature to prevent yourself from
incorporating hard-to-spot logic errors into your spreadsheets:
is replace with
,- ,(0-
(- (0-
=- =0- <-- this one is IMPORTANT, since = and - are adjacent
on most keyboards, and it's easy to type `=-' when
you only meant to type `='
Continue to:
My Books
