Current location - Loan Platform Complete Network - Loan intermediary - In excel, one column is debit and the other column is credit. How to change it into a class, positive debit and negative credit?
In excel, one column is debit and the other column is credit. How to change it into a class, positive debit and negative credit?
C2=IF(ROW(A 1)>COUNT($A$2:$B$6),",IF(MOD(ROW(A 1),2), 1,- 1)*OFFSET($A$ 1,round (row (a668))。

1.MicrosoftExcel is a spreadsheet software written by Microsoft for computers using Windows and AppleMacintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, as a component of MicrosoftOffice, after the release of version 5.0, Excel began to become the overlord of spreadsheet software on the applicable operating platform.

Second, MicrosoftOffice is a set of office software developed by Microsoft, which can run on MicrosoftWindows, WindowsPhone, Mac series, iOS and Android. Like other office applications, it includes federated servers and Internet-based services. Since the 2007 version of Office, it has been called "OfficeSystem" instead of "OfficeSuite", which reflects the fact that they include servers.

3.Office was originally a promotion name, which appeared in1early 1990s, referring to a collection of software sold separately before. At that time, the main promotion focus was: buying a collection saved a lot of money than buying it alone. The original versions of Office included Word, Excel and PowerPoint. "Professional Edition" included MicrosoftAccess, before MicrosoftOutlook. With the change of time, Office applications gradually integrate and share some functions, such as spelling and grammar checking, OLE data integration and VBA scripting language. Microsoft has expanded Office into a development platform, where third-party software can be downloaded from specialized stores.

Fourth, Office is often the standard for making documents and files. There are some functions that other products do not have, but other products also have functions that Office lacks. Since Microsoft2007OfficeSystem in 2007, there has been a completely different user interface from the previous version. This interface is called Ribbon interface and has been used in MicrosoftOffice20 10, MicrosoftOffice20 13 and MicrosoftOffice20 16.

5. The original version of 5.MicrosoftOffice was launched in 1989, and the initial operation was on the Macintosh platform of Apple computer. Since the introduction of word processing, spreadsheet and presentation software, MicrosoftOffice has been in the leading position. Starting from Microsoft Office 2013 (Office15), more functions of Office provide cross-platform support, and programs of Android and IOS mobile operating systems are provided. These features are mainly used for the desktop version. Since the release of MicrosoftOffice20 16, the updates of the same version number on all platforms are roughly the same.

6. Microsoft Office Mobile (Office15): Microsoft's mobile device version of Office. The main function is to enable Office365 subscribers to use their Office subscriptions on mobile devices. This version has been criticized because the program is only open to paid subscribers, and has limited functions for non-subscribers (only the contents of files can be read, but not modified), and it can't display the file format correctly and store Office files in the device. At present, the program is still available on GooglePlay, but it only supports devices running Android4.4 version 4.4 or lower.