Excel for Grannies - Part 2 - Simple calculation

Functions

Functions can easily be combined to create more complex calculations. As per the below example we are multiplying the values in three cells, length, width and height or order to find the volume of a object. I have added another function which converts that result into another unit. Simply by multiplying the volume in cubic meters by 35.3147 we get the result in cubic feet.

We can easy multiply the contents of cells by navigating to the result cell then enter "=" A1 * A2 * A3 etc.. This will multiply the values in cells A1,A2 and A3.

Looking at above screen shot we can see how the three values Height, Width and Length are entered in centimeters.

Cell D2 "Volume m3" has the following cell value (=A2*B2*C2/1000000), this simply multiplies the three values together and divides it by 1,000,000 to covert it into cubic meters.

Cell E2 "Volume cft" multiplies D2 by 35.3147 to convert it into cubic feet (=D2 * 35.3147)

For the topic of international shipping, items in containers are not often weighed, therefore a weight is calculated from a density factor. In Cell F2 the weight is calculated by multiplying E2 by 6.5 which is a typical density factor used by many shipping companies.

Copying Formulas

Formulas (Formulae) can easily be copied, when this is done they automatically reference adjacent cells for convenience, however this function can be turned off. If you see the example below, I have selected cells D2, E2 and F2.

On the bottom left corner of F2 you will see a black square, I clicked on this and dragged it down to F8. By doing this on the formulas are copied/repeated down to F8.

As you can see, I have entered some more values into the height, width and length columns and the formulas have already been calculated in the respective columns. This is very useful where a large list of calculations is needed.

Please check back for more updates.

More by this Author


Comments 1 comment

KristieRaburn profile image

KristieRaburn 5 years ago from California

I love the title of this article. It drew me in and made me read the text.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working