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?
|