Thread: Max, Ceiling, If, Etc
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris W via OfficeKB.com
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote