From: Barb H on 17 Mar 2010 15:54 I am trying to find a formula that automatically calculates multiples of 32. if it is not a multiple of 32 then I wnat he cell to be blank. Any suggestions? if page count =32 then sig should = 1 if page count = 64 then sig should = 2 and so on.... See spreadsheetsample below. I manually have to fill in the 'sig' column with the number. Thanks, barb # of pages Page count Sig 2 2 2 4 2 6 2 8 2 10 2 12 2 14 2 16 2 18 2 20 2 22 2 24 2 26 2 28 2 30 2 32 1 2 34 2 36 2 38 2 40 2 42 2 44 2 46 2 48 2 50 2 52 2 54 2 56 2 58 2 60 2 62 2 64 2 2 66 2 68 2 70 2 72 2 74 2 76 2 78 2 80 2 82 2 84 2 86 2 88 2 90 2 92 2 94 2 96 3 2 98 2 100 2 102 2 104 2 106 2 108 2 110 2 112 2 114 2 116 2 118 2 120 2 122 2 124 2 126 2 128 4 2 130 2 132 2 134 2 136 2 138 2 140 2 142 2 144 2 146 2 148 2 150 2 152 2 154 2 156 2 158 2 160 5 2 162 2 164 2 166 2 168 2 170 2 172 2 174 2 176 2 178 2 180 2 182 2 184 2 186 2 188 2 190 2 192 6 2 194 2 196 2 198 2 200 2 202 2 204 2 206 2 208 2 210 2 212 2 214 2 216 2 218 2 220 2 222 2 224 7 From: Paul C on 17 Mar 2010 16:01 the MOD function will test for a remainder (thus determine if a number is a multiple) use the formula =IF(MOD(A1,32)=0,A1/32,"") -- If this helps, please remember to click yes. "Barb H" wrote: > I am trying to find a formula that automatically calculates multiples of 32. > if it is not a multiple of 32 then I wnat he cell to be blank. Any > suggestions? > > if page count =32 then sig should = 1 > if page count = 64 then sig should = 2 and so on.... > > See spreadsheetsample below. I manually have to fill in the 'sig' column > with the number. > > Thanks, barb > > # of pages Page count Sig > > > > 2 2 > 2 4 > 2 6 > 2 8 > 2 10 > 2 12 > 2 14 > 2 16 > > 2 18 > 2 20 > 2 22 > 2 24 > 2 26 > 2 28 > 2 30 > 2 32 1 > 2 34 > 2 36 > 2 38 > 2 40 > 2 42 > 2 44 > 2 46 > 2 48 > 2 50 > 2 52 > 2 54 > 2 56 > 2 58 > 2 60 > 2 62 > 2 64 2 > 2 66 > 2 68 > 2 70 > 2 72 > 2 74 > 2 76 > 2 78 > 2 80 > 2 82 > 2 84 > 2 86 > 2 88 > > 2 90 > 2 92 > 2 94 > 2 96 3 > 2 98 > 2 100 > 2 102 > > 2 104 > 2 106 > 2 108 > 2 110 > 2 112 > 2 114 > 2 116 > 2 118 > 2 120 > 2 122 > 2 124 > 2 126 > 2 128 4 > 2 130 > 2 132 > 2 134 > 2 136 > 2 138 > 2 140 > 2 142 > 2 144 > 2 146 > 2 148 > 2 150 > 2 152 > 2 154 > 2 156 > 2 158 > 2 160 5 > > 2 162 > 2 164 > 2 166 > 2 168 > 2 170 > 2 172 > 2 174 > 2 176 > 2 178 > 2 180 > 2 182 > 2 184 > 2 186 > 2 188 > 2 190 > 2 192 6 > 2 194 > 2 196 > 2 198 > 2 200 > 2 202 > 2 204 > 2 206 > 2 208 > 2 210 > 2 212 > 2 214 > 2 216 > 2 218 > 2 220 > 2 222 > 2 224 7 > >  |  Pages: 1 Prev: Average with ConditionNext: sumif concatenate formula