2*2*4'8"*2'4"*0'9"=32.64'

The correct result should be 32.66666667

This array formula works on your (very limited) sample data:

=PRODUCT(IF(ISNUMBER(FIND("'",A1:E1)),LEFT(A1:E1,F IND("'",A1:E1)-1)+MID(SUBSTITUTE(A1:E1,"""",""),FIND("'",A1:E1)+1 ,3)/12,A1:E1))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"vmohan1978" wrote in message
...
Need a Formula for the Following


No No L B D Qty
Remarks

2 2 4' 8" 2'4" 0' 9" -------
I
need formula that multiplies( 2*2*4'8"*2'4"*0'9"=32.64')