Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
251x Filetype XLSX File size 0.07 MB Source: www.ablebits.com
Sheet 1: Multiply columns - Examples
| Sample Workbook to Multiply Columns in Excel | ||||||
| The workbook shows a few different ways to multiply one column by another and multiply a column of numbers by the same number. | ||||||
| Author | Ablebits.com | |||||
| Last update | 29-Sep-17 | |||||
| Tutorial URL | How to multiply columns in Excel | |||||
| Examples: | ||||||
| • | Multiply two columns | |||||
| • | Multiply several columns | |||||
| • | Multiply a column by a number | |||||
| Item | Price | Qty. | Multiplication | |||||||||||||||
| Multiply sign | PRODUCT | Array formula | ||||||||||||||||
| Apples | $2.00 | 20 | $40.00 | $40.00 | $40.00 | |||||||||||||
| Oranges | $1.90 | 30 | $57.00 | $57.00 | $57.00 | |||||||||||||
| Lemons | $2.50 | 35 | $87.50 | $87.50 | $87.50 | |||||||||||||
| Grapes | $1.99 | 15 | $29.85 | $29.85 | $29.85 | |||||||||||||
| Item | Price | Qty. | VAT % | Multiplication | |||||||||||
| Multiply sign | PRODUCT | Array formula | |||||||||||||
| Apples | $2.00 | 20 | 10% | $4.00 | $4.00 | $4.00 | |||||||||
| Oranges | $1.90 | 30 | 11% | $6.27 | $6.27 | $6.27 | |||||||||
| Lemons | $2.50 | 35 | 13% | $11.38 | $11.38 | $11.38 | |||||||||
| Grapes | $1.99 | 15 | 9% | $2.69 | $2.69 | $2.69 | |||||||||
