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:

• prev: 10.19 What is the correct, registered MIME Content-Type for Excel files?
• Index
• next: 10.21 Why does Excel claim I have an invalid `SYLK' file?

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro