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!
Bookmarks