Urgent help required - Excel Formula

[Glenn]

Hi,

A couple of things i need help with :-

I need to calculate the volume of a room.
I have four cells, Height, Width, Depth and Total
I need to put a value in each of the cells Height, Width
and depth, but need a formula for the totals cell that
will look at the height, width and depth and give me a
total volume for the room all measurements in metres
cubed.

 

[jaf]

Hi Glen,
If your data is in meters in d1 enter =a1*b1*c1

 

[helmut sager]

Try this one:
=a1*b1*c1
assuming that a=width, b=length and c=height.

but I guess, that you already knew before.

If your problem concerns conversion of inches and feet into cm and
here are to parameters which will help:

1 inch = 2,54 cm = 0,0254 m
1 foot = 30,48 cm = 0,3048 m

any further questions just let me know