| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Combine functions into one cell
I have two macros =Feet and =LenText. Feet converts 12' 0" into 12.00
(decimal format), LenText converts decimal to feet & inches. Now heres what I would like, I will enter feet and inchs into cell A5. Cell C5 will use macro =feet from cell A5 then subtract that number from Cell G5 & finally use =LenText to convert it back to feet & inches(All of this will happen in Cell C5 if possible). Excell 2000 on Windows ME Anyhelp would be great. |
|
#2
|
|||
|
|||
|
If by macros you mean user-defined functions, then presumably you would use
=LenText(G5-Feet(A5)) " wrote: I have two macros =Feet and =LenText. Feet converts 12' 0" into 12.00 (decimal format), LenText converts decimal to feet & inches. Now heres what I would like, I will enter feet and inchs into cell A5. Cell C5 will use macro =feet from cell A5 then subtract that number from Cell G5 & finally use =LenText to convert it back to feet & inches(All of this will happen in Cell C5 if possible). Excell 2000 on Windows ME Anyhelp would be great. |
|
#3
|
|||
|
|||
|
Thanks
"Duke Carey" wrote: If by macros you mean user-defined functions, then presumably you would use =LenText(G5-Feet(A5)) " wrote: I have two macros =Feet and =LenText. Feet converts 12' 0" into 12.00 (decimal format), LenText converts decimal to feet & inches. Now heres what I would like, I will enter feet and inchs into cell A5. Cell C5 will use macro =feet from cell A5 then subtract that number from Cell G5 & finally use =LenText to convert it back to feet & inches(All of this will happen in Cell C5 if possible). Excell 2000 on Windows ME Anyhelp would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Copying and Filling Cell With Functions | Excel Discussion (Misc queries) | |||
| Multiple functions in one cell | Excel Worksheet Functions | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| How to combine 2 different SUMPRODUCT criteria into one cell????? | Excel Worksheet Functions | |||
Hybrid Mode
