Max, Ceiling, If, Etc
 

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

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

Max, Ceiling, If, Etc
 

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

"Chris W via OfficeKB.com" wrote:

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

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

Max, Ceiling, If, Etc
 

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

Max, Ceiling, If, Etc
 

If by

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

you mean make O26 an even number try replacing the MROUND with:

ROUND(O26+MOD(O26,2),0)
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Chris W via OfficeKB.com" <u12698@uwe wrote in message
news:57c237ffd53b8@uwe...
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