2 Ways to Reverse the Number Sign Positive Negative in Excel
Автор: Excel Campus - Jon
Загружено: 2017-03-02
Просмотров: 668032
Описание:
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
Learn 2 ways to reverse the sign of a number from positive to negative or negative to positive in Excel.
https://www.excelcampus.com/tips/reve...
Flipping or reversing the number signs to positive or negative is a common task in Excel. In this video we look at two quick ways to accomplish this.
First, we can use a formula to multiply an existing cell by negative one *-1.
Second, we can use the Paste Special Multiply Operation to copy a cell that contains a -1 and multiply an existing range of cells to reverse the signs.
00:00 Introduction
01:33 Multiply
02:13 Copy Paste Special
02:55 Go to Special
04:19 Paste Special for Formulas
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: