Combine functions into one cell

G

Guest

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.
 
G

Guest

If by macros you mean user-defined functions, then presumably you would use

=LenText(G5-Feet(A5))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fractions, Feet, Inches, & macros 8
Excel How To Convert Decimal To Inches 2
convert decimal inches into feet and inches 4
Calculating the Area of objects in Feet and Inches 6
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Combine 2 columns in a dynamic range into one 7
How to combine several successive rows into one cell 2
Splitting one cell into three. 2

Top