Thank you very much. I've never used the "choose" function before. I'll
definately try it.

"Roger Govier" wrote:

Hi Forrest

Try
=INT(CONVERT(E17,"m","ft"))&" feet "&INT(MOD(CONVERT(E17,"m","ft"),1)*12)&
" "&CHOOSE((ROUND(((E17*3.2808-INT(ROUND(E17*3.2808,2)))
*12-TRUNC((E17*3.2808-INT(ROUND(E17*3.2808,2)))*12))/0.125,0))
,"1/8","1/4","3/8","1/2","5/8","3/4","7/8")&" inches"

I used the convert function, to go from metres to feet (I think you need the
Analysis Toolpak loaded for this TollsAddinsAnalysis Toolpak).
I couldn't be bothered to alter your calculation for the fractions of an
inch, I just made it one calculation with a choose dependent upon its result.

With 10 in E16 it returns 32 feet 9 3/4 inches.


Regards

Roger Govier


Forrest wrote:
Congratulations on figuring out what the equation does. 3.2808 is the
conversion from meters to feet. A28 is simply the cell with the metric
length to convert.
The purpose is to copy this one cell formula into any spreadsheet next to a
cell with a metric length to convert. If I spilt up the equation into two
cells it works fine, but that defeats my goal.

"Biff" wrote:


So, you're trying to convert a value into feet and fractions of an inch.

What is in A28 and what does 3.2808 have to do with it?

That is one nasty formula, 928 characters! <g

Why don't you explain exactly what you're trying to do and maybe we can come
up something more manageable.

Biff

"Forrest" wrote in message
...

It looks like this:

=INT(ROUND(A28*3.2808,2))&"' -
"&TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12)&"
"&IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=1,"1/8",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=2,"1/4",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=3,"3/8",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=4,"1/2",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=5,"5/8",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=6,"3/4",IF((ROUND(((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12-TRUNC((A28*3.2808-INT(ROUND(A28*3.2808,2)))*12))/0.125,0))=7,"7/8","")))))))&""""

What occurs is Excel says there is an error in the formula, once it gets
to
a certain size and highlights one of the functions. In this case it is
the
Round function. There isn't a logic or syntax error though. It could be a
nesting problem. I have seven nested If statements, each with 3 Round
functions.
This equation has 59 functions, so I am guessing that there is a limit to
the number in one cell.

"Biff" wrote:


Hi!

What's the formula look like?

What does "before it blows up" mean?

Biff

"Forrest" wrote in message
...

I have a formula in one cell with several functions used multiple times.
It
seems though that 25 times is the max for the Round function before it
blows
up. Why?