Simple volume calculations in Excel

Throughout this chapter, we will be computing the volume of a rectangular shape, such as a shipping box by multiplying its length by its width and height. Having a consistent calculation to follow this chapter will make it easier to focus on the Excel features and functions that I’ll be covering along the way. Let’s open the Chapter 11 - Names, LET, and LAMBDA.xlsx example workbook for this chapter and get started.

Multiplication

Anyone new to Microsoft Excel typically starts out with basic computations such as addition, subtraction, multiplication, and division, so let's begin there. Rest assured, we won’t linger long here; we’re mostly establishing a framework that we can build onto:

Figure 11.1 – Contrasting simple multiplication with the PRODUCT function

Cells C3:C5 of the Multiplication worksheet in Figure 11.1 contain the length, width, and height of a hypothetical box in...