I have to collect four readings for my job. They need to be averaged which i
all simple enough. In the sixth column i need a formula that will convert
the average into a reading from a chart we have shown below...
For instance the four readings will have an average of 202. The sixth
reading should be 1.6 as shown below..

170 -2.2 180 -2.0 190 -1.8 200 -1.6 210 -1.4 220 -1.3
171 -2.2 181 -1.9 191 -1.8 201 -1.6 211 -1.4 221 -1.3
172 -2.2 182 -1.9 192 -1.7 202 -1.6 212 -1.4 222 -1.3
173 -2.1 183 -1.9 193 -1.7 203 -1.6 213 -1.4 223 -1.3
174 -2.1 184 -1.9 194 -1.7 204 -1.5 214 -1.4 224 -1.3
175 -2.1 185 -1.9 195 -1.7 205 -1.5 215 -1.4 224 -1.3
176 -2.1 186 -1.8 196 -1.7 206 -1.5 216 -1.4 226 -1.3
177 -2.0 187 -1.8 197 -1.6 207 -1.5 217 -1.4 227 -1.2
178 -2.0 188 -1.8 198 -1.6 208 -1.5 218 -1.3 228 -1.2
179 -2.0 189 -1.8 199 -1.6 209 -1.5 219 -1.3 229 -1.2

Assume your table is in the range A1:L10.

A15 = 202

=SUMIF(A1:K10,A15,B1:L10)

--
Biff
Microsoft Excel MVP


"popmart" wrote in message
...
I have to collect four readings for my job. They need to be averaged which
i
all simple enough. In the sixth column i need a formula that will
convert
the average into a reading from a chart we have shown below...
For instance the four readings will have an average of 202. The sixth
reading should be 1.6 as shown below..

170 -2.2 180 -2.0 190 -1.8 200 -1.6 210 -1.4 220 -1.3
171 -2.2 181 -1.9 191 -1.8 201 -1.6 211 -1.4 221 -1.3
172 -2.2 182 -1.9 192 -1.7 202 -1.6 212 -1.4 222 -1.3
173 -2.1 183 -1.9 193 -1.7 203 -1.6 213 -1.4 223 -1.3
174 -2.1 184 -1.9 194 -1.7 204 -1.5 214 -1.4 224 -1.3
175 -2.1 185 -1.9 195 -1.7 205 -1.5 215 -1.4 224 -1.3
176 -2.1 186 -1.8 196 -1.7 206 -1.5 216 -1.4 226 -1.3
177 -2.0 187 -1.8 197 -1.6 207 -1.5 217 -1.4 227 -1.2
178 -2.0 188 -1.8 198 -1.6 208 -1.5 218 -1.3 228 -1.2
179 -2.0 189 -1.8 199 -1.6 209 -1.5 219 -1.3 229 -1.2