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

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

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


.

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


.

Clarification:

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?

Why not just use the values of cell1 and cell2 to come up with 6.25 rather
than using that long formula to convert from the text string 6'3"?

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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


.

This newsgroup isn't a binary group, so attachments aren't allowed.
--
David Biddulph

"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