Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples.

preview_player
Показать описание

See how to Multiply Quantity Times Debit or Credit Column
1. (00:08 min) Formulas see empty cells as zero.
2. (00:34 min) Formula 1: =SUM(G9*E9,G9*F9)
3. (01:06 min) Formula Evaluator keyboard: Alt, M, V
4. (01:49 min) Formula 2: =SUMPRODUCT(E9:F9*G9). This is an array formula.
5. (02:56) Formula 3: =IF(F9=0,G9*E9,G9*F9)

Multiply Quantity Times Debit or Credit Column. Formulas see empty Cell as Zero
  1. excelisfun
  2. Excel 2013
  3. Excel 2003
  4. Excel 2007
  5. Excel 2010
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:03:47

Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples.

Excel Magic Trick 0:12:45

Excel Magic Trick 1056 Excel 2013 Slicer Formulas (nowtelugu.com)

Excel Magic Trick 0:02:52

Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR

Multiplying with Microsoft 0:01:43

Multiplying with Microsoft Excel

Microsoft Office - 0:02:37

Microsoft Office - How to multiply numbers in Microsoft Excel

Excel Magic Trick 0:04:06

Excel Magic Trick 1069 Displaying Decimal and Fractional Inches in Excel 13 or 2 5 or 2 13

Excel Magic Trick 0:06:51

Excel Magic Trick 1065 SUMIFS Month Over Month Sales Calculations From Transactional Data Set

Mr Excel & 0:05:28

Mr Excel & excelisfun Trick 151: Put 1 of 2 Formulas into Cell Based on 2 Conditions: IF or CHOO...

Excel Tips: Define 0:03:23

Excel Tips: Define Excel Table

How To Copy 0:00:17

How To Copy Formula To Fill Section - Basics and Shortcuts for Excel

how to learn 0:00:50

how to learn balance sheet debit & credit

RelAbsRef (Excel-01) 0:14:05

RelAbsRef (Excel-01)

36 Time Formula 0:01:13

36 Time Formula

How to do 0:00:34

How to do General Formatting in Excel - Basics and Shortcuts for Excel

1 10 Create 0:02:40

1 10 Create Scattered Curved Line Charts in Excel

Running Balance Test 0:02:23

Running Balance Test

Excel Transpose 0:01:58

Excel Transpose

CFA Level 2 0:14:02

CFA Level 2 Correlation and Regression in Quantitative Techniques

Debit and Credit 0:01:06

Debit and Credit

Managing Business Finances 0:01:25

Managing Business Finances & Accounting; Extending Credits To Your Customers

Create quick reports 0:14:38

Create quick reports with Pivot tables

Project 6c 0:01:20

Project 6c Filtering by Font Color

How to Create 0:06:38

How to Create a Business Accounts Ledger in Microsoft Excel : Debit Credit Balance [Urdu / Hindi]

Sage Instant Accounts 0:00:57

Sage Instant Accounts 2014 - Import stock quantities from an Excel or CSV file

Комментарии
Автор

Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples. 

excelisfun
Автор

Thank you Mr.Girvin! You totally saved my day, I really appreciate you enthusiasm and love of learning&teaching such a ROCKSTAR!!

InYourFaceBirds
Автор

hello frn  I want formula for Quantity.  After you insert amount in Debit & credit then automatically calculate in quantity column line

rahulmukhiya