224x 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 | |||||||||
no reviews yet
Please Login to review.