If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto calculate
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 |
#2
|
|||
|
|||
Auto calculate
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 |
Thread Tools | |
Display Modes | |
|
|