I'm not following you on this.

You have 2 cells:

cell1 = 6
cell2 = 3

You convert that to a text string to represent Feet - Inches = 6'3"

Then you use that long formula to convert 6"3" into a decimal number 6.25.

So, why use that long formula to convert the text string 6'3" into a decimal
number 6.25, why not just use cell1 and cell2?

--
Biff
Microsoft Excel MVP


"vmohan1978" wrote in message
...
oK .
My Problem is in ft and inches .
3) F G H I J K
L
M N O P Q R
4) lENGTH Breadth Depth Qty




In J iam entering number ( as feet) (6) and K entering number as ( Feet)
(3)
In L i entered formula K3&IF(K3="","","'")&L3&IF(L3="","","""") and
results(6'3" )

same way it appies to MNO and PQR
In F i written formula it shows as 6.25 WRT to L 6'3"
Formula is
(IF(IF(ISNUMBER(FIND("'",M3)),FIND("'",M3),0)=0,0, LEFT(M3,IF(ISNUMBER(FIND("'",M3)),FIND("'",M3),0)-1))+(IF((IF(ISNUMBER(FIND("""",M3)),FIND("""",M3), 0)=0),0,MID(M3,IF(IF(ISNUMBER(FIND("'",M3)),FIND(" '",M3),0)0,IF(ISNUMBER(FIND("'",M3)),FIND("'",M3) ,0)+1,1),IF(ISNUMBER(FIND("""",M3)),FIND("""",M3), 0)-IF(IF(ISNUMBER(FIND("'",M3)),FIND("'",M3),0)0,IF( ISNUMBER(FIND("'",M3)),FIND("'",M3),0)+1,1))))/12)

same formula i applied the formula in G and H also
In I i applied formula as Product of (F*G*H) . If I won't type in M and N
H
shows 0 similarly if i won't type in P& Q , H shows 0 .

I need a formula in such a way that I f i wont enter number in M, N and
P,Q
G & H should show blank . But when I multiply F,G,H i should get product.

Hope you understand my problem.

"T. Valko" wrote:

You can't attach files using the MS Discussion Group web interface.

--
Biff
Microsoft Excel MVP


"vmohan1978" wrote in message
...
Dear all ,
Please let me know how to attach the file , in that way i can explain
my
problem in better way


.