View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
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" <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?