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

[tomtom]

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

 

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP

 

[John C]

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

 

[Bernard Liengme]

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

 

[ShaneDevenshire]

And even shorter:

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

 

[Bernard Liengme]

Yes but the dimensional analysis is wrong <grin>