Remember Me?

#1
November 6th 08, 05:41 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 1
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
November 6th 08, 05:45 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 5,441
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
November 6th 08, 05:58 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 1,358
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
November 6th 08, 08:50 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,393
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
November 7th 08, 11:48 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 2,344
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
November 8th 08, 04:07 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,393
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael M Excel Worksheet Functions 0 August 7th 06 11:19 PM OcalaElaine Excel Worksheet Functions 4 June 14th 06 06:43 PM OcalaElaine Excel Worksheet Functions 4 June 13th 06 10:03 PM Daniel Excel Worksheet Functions 3 February 16th 06 08:57 AM demeulpa Charts and Charting in Excel 1 August 10th 05 05:28 PM

All times are GMT +1. The time now is 02:40 AM.