Prev: Average with Condition
Next: sumif concatenate formula
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 Condition
Next: sumif concatenate formula