Urgent help required - Excel Formula

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.

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


--

John

johnf202 at hotmail dot com


"Glenn" wrote in message
...
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.

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 m
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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/