Search33 wrote:
Hi Chris,

try this.

=MAX(8,IF('Deck Design'!B7=0," ",MROUND('Lumber'!O26,2)))

Please note, you need to enable the analysis tookpack for the MROUND
function to work. See the excel documantation for MROUND for instructions on
how to do this.

- Search

=MAX(8,IF('Deck Design'!B7=0," ",Lumber!O26+2))

I am trying to get this formula to return a minimum of 8, and round to the
next multiple of 2.

Any help is appreciated.


Hmm, is there anyway around installing the analysis toolpack to get the same
result? When I try and install it I get an "ANALYS32.XLL is not a valid add-
in" I'm not sure if it is corrupt or what.

This is an old copy of Excel 97 that I do not have access to the install
disks/cd's to try and re-install from.

If I made the corrections at home on excel 2003 with the data analysis pack
installed, then transferred it here, would the analysis pack be installed in
the worksheet that I bring, or is it a programwide file?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1