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.

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.

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.