» Multiplying a Range by -1 in One Operation
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
To multiply a range of numbers by -1:1. In any cell, type -1.
2. Select the cell and press Ctrl+C to copy.
3. Select the range to be multiplied by -1.
4. Press Shift+F10 or right-click, and then select Paste Special from the shortcut menu.
5. Select the Multiply option button, and then click OK.
Note: *-1 and parentheses are added in any cell with a formula.
Book Store:
Recommended Books:
- Advanced modelling in finance using Excel and VBA
- East of Eden (Oprah's Book Club)
- Financial Modeling - 2nd Edition
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The 22 Immutable Laws of Branding
No comments have been submitted.
