thanks guys the formulas work except that i failed to give you all the parameters. first off the width and length will be in feet and the depth will be in inches. so, the formula would normally look like this (A1*B1*(C1*12))/27
could you please help times the depth by 12 and divide it all by...
i have 3 cells that multiply to calculate cubic yds (W x L x Depth)
I need a formula that will show lineal feet when L is populated and W & D are 0s. or show square foot W & L are populated and D is 0 or show cubic yards if W & L & C are all populated