| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use a measurement abbreviation in cell with formula
How can I format the cell to hold the amt to calculated with the measurement
unit in the same cell? i.e. b27 needs to read 158 sq ft c27 is $ amt ($0.17) d27 is the formula =(b27*c27) When I enter in just the number 158 it calculates in d27 correctly, but when I add sq ft after 158, d27 shows an error message #VALUE! Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
