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