Another Rounding Question

Ok, different problem. I have now been using the rounding function and things have been going a lot smoother. I now have a need to round two different parts to the same formula, and I can't. I am asuming that Excel won't let you round twice.

I am using:
=((D4-4)*12)/(ROUNDUP((((D4-4)*12)/64),0))

But need to round the answer up again, tried to make it:
=ROUND((D4-4)*12)/(ROUNDUP((((D4-4)*12)/64),0)), 0

with no luck, Excel yells.

Maybe there is a way to simplify the formula? the *12 is for converting feet into inches and the answer can be left into inches, just rounded to the nearest inch.

THANKS AGAIN!

Seems like a bit of an odd calculation to me, what's it supposed to do? What sort of values do you have in D4?

shg: thanx for the reworked formula...looks much better, will plug it in tommorrow and it should do the trick!

daddylonglegs: I am taking a length subtracting the ends (2 ft.), and from the center evenly spacing points out back to the 2ft mark.

The figure in D4 changes each time I run the calculations.

OK, I think I get it now, thanks for the explanation....

....here's a slightly different way....

=ROUND((D4-4)/CEILING((D4-4)/64,1/12),0)