how do i find the volume of a 100'*30'*1' footing in cubic yards?
 

how do i find the volume of a 100'*30'*1' footing in cubic yards?

how do i find the volume of a 100'*30'*1' footing in cubic yards?
 

Calculate the volume in cubic feet (LxWxD) and then divide by 27

HTH,
Bernie
MS Excel MVP


"tomtom" wrote in message
...
how do i find the volume of a 100'*30'*1' footing in cubic yards?

how do i find the volume of a 100'*30'*1' footing in cubic yards?
 

Here's a much more difficult way:
=CONVERT(CONVERT(CONVERT(100*30*1,"ft","yd"),"ft", "yd"),"ft","yd")
--
** John C **

"tomtom" wrote:

how do i find the volume of a 100'*30'*1' footing in cubic yards?

how do i find the volume of a 100'*30'*1' footing in cubic yards?
 

Or =(100*30*1)*CONVERT(1,"ft","yd")^3
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
Here's a much more difficult way:
=CONVERT(CONVERT(CONVERT(100*30*1,"ft","yd"),"ft", "yd"),"ft","yd")
--
** John C **

"tomtom" wrote:

how do i find the volume of a 100'*30'*1' footing in cubic yards?

how do i find the volume of a 100'*30'*1' footing in cubic yar
 

And even shorter:

=100*30*CONVERT(1,"ft","yd")^3

--
Thanks,
Shane Devenshire


"Bernard Liengme" wrote:

Or =(100*30*1)*CONVERT(1,"ft","yd")^3
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
Here's a much more difficult way:
=CONVERT(CONVERT(CONVERT(100*30*1,"ft","yd"),"ft", "yd"),"ft","yd")
--
** John C **

"tomtom" wrote:

how do i find the volume of a 100'*30'*1' footing in cubic yards?

how do i find the volume of a 100'*30'*1' footing in cubic yar
 

Yes but the dimensional analysis is wrong <grin
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ShaneDevenshire" wrote in
message ...
And even shorter:

=100*30*CONVERT(1,"ft","yd")^3

--
Thanks,
Shane Devenshire


"Bernard Liengme" wrote:

Or =(100*30*1)*CONVERT(1,"ft","yd")^3
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C" <johnc@stateofdenial wrote in message
...
Here's a much more difficult way:
=CONVERT(CONVERT(CONVERT(100*30*1,"ft","yd"),"ft", "yd"),"ft","yd")
--
** John C **

"tomtom" wrote:

how do i find the volume of a 100'*30'*1' footing in cubic yards?