Max, Ceiling, If, Etc

  • Thread starter Chris W via OfficeKB.com
  • Start date
C

Chris W via OfficeKB.com

=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.
 
S

Search33

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
 
C

Chris W via OfficeKB.com

Search33 said:
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
Click to expand...


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?
 
Top