| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to create formula to convert?
I have a column of measurments ie. 33' 8 1/2" which I need to convert to
numeric value to compute square footage. all I get as result is error. A1 = width, A2: A40 = unique measurments.... D2:D40 = length measurments.... I need to convert (ft) & (in) to numeric value multiply A$ by D$ = X and convert? I think excell can do this but I'm to green to figure out? Any help is greatly appreciated. Thank you.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| In two workbooks, how do I create a formula that will look at a o. | Excel Discussion (Misc queries) | |||
| Create formula | Excel Worksheet Functions | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Threaded Mode
