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?