| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cubic Parabola or Cubic Spiral | Excel Worksheet Functions | |||
| Convert cubic centimeters to fluid ounces and cubic centimeters | Excel Worksheet Functions | |||
| convert cubic centimeters to fluid ounces and cubic centimeters | Excel Worksheet Functions | |||
| In excel how do you find the cubic root of a number? | Excel Worksheet Functions | |||
| standard heading en footing | Charts and Charting in Excel | |||
Linear Mode
