Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i convert feet and inches to a decimal value?
I have an assignment that shows me this equation but it doesnt seem to
work, =LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12) |
#2
|
|||
|
|||
"go_chrisg" wrote in message ... I have an assignment that shows me this equation but it doesnt seem to work, =LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12) Chris It's close, but not quite right. Firstly I assume A1 is in the format ft<spacein. Your formula needs to look for the space, so you need to add a space between all 3 instances of "". Secondly, the final "find" argument is wrong. As it stands, it will only pick up the first digit after the space for the inches. Deleting the -1 from after the final A1 will cure this. Ian |
#3
|
|||
|
|||
hmmmmm it seem i still am hving problems....heres the corrections to it
=LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND(" ",A37))/12)) "IC" wrote: "go_chrisg" wrote in message ... I have an assignment that shows me this equation but it doesnt seem to work, =LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12) Chris It's close, but not quite right. Firstly I assume A1 is in the format ft<spacein. Your formula needs to look for the space, so you need to add a space between all 3 instances of "". Secondly, the final "find" argument is wrong. As it stands, it will only pick up the first digit after the space for the inches. Deleting the -1 from after the final A1 will cure this. Ian |
#4
|
|||
|
|||
Hi!
Try this: A1 = 3<space6 meaning 3'6" =(--LEFT(A1,FIND(" ",A1)-1)*12+--MID(A1,FIND(" ",A1)+1,255))/12 Returns 3.5 Biff "go_chrisg" wrote in message ... hmmmmm it seem i still am hving problems....heres the corrections to it =LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND(" ",A37))/12)) "IC" wrote: "go_chrisg" wrote in message ... I have an assignment that shows me this equation but it doesnt seem to work, =LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12) Chris It's close, but not quite right. Firstly I assume A1 is in the format ft<spacein. Your formula needs to look for the space, so you need to add a space between all 3 instances of "". Secondly, the final "find" argument is wrong. As it stands, it will only pick up the first digit after the space for the inches. Deleting the -1 from after the final A1 will cure this. Ian |
#5
|
|||
|
|||
"go_chrisg" wrote in message ... hmmmmm it seem i still am hving problems....heres the corrections to it =LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND(" ",A37))/12)) .... which is exactly what I suggested, except the change of cell reference from A1 to A37 (which I couldn't have guessed from your original post). Anyway, I'm glad it's sorted. Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format number in feet and inches | Excel Discussion (Misc queries) | |||
How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
Measurement, in feet and inches, in Excel | Excel Discussion (Misc queries) | |||
Converting inches to feet & inches. | Excel Worksheet Functions | |||
How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions |