Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Something like CEILING or FLOOR | Excel Worksheet Functions |