how to attach file

  • Thread starter Thread starter vmohan1978
  • Start date Start date
V

vmohan1978

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.
 
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?
 
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?
Click to expand...

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"?
 
Back
Top