Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 6th 08, 06:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default 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?

  #2   Report Post  
Old November 6th 08, 06:45 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,441
Default 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?



  #3   Report Post  
Old November 6th 08, 06:58 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,358
Default 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?

  #4   Report Post  
Old November 6th 08, 09:50 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default 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" <[email protected] 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?



  #5   Report Post  
Old November 8th 08, 12:48 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default 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" <[email protected] 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?






  #6   Report Post  
Old November 8th 08, 05:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default 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" <[email protected] 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?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cubic Parabola or Cubic Spiral Michael M Excel Worksheet Functions 0 August 7th 06 11:19 PM
Convert cubic centimeters to fluid ounces and cubic centimeters OcalaElaine Excel Worksheet Functions 4 June 14th 06 06:43 PM
convert cubic centimeters to fluid ounces and cubic centimeters OcalaElaine Excel Worksheet Functions 4 June 13th 06 10:03 PM
In excel how do you find the cubic root of a number? Daniel Excel Worksheet Functions 3 February 16th 06 09:57 AM
standard heading en footing demeulpa Charts and Charting in Excel 1 August 10th 05 05:28 PM


All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017