Formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 15 Aug 2006 22:37 GMT

I need a formual that will give me a reult when I enter in the date and
hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
would like a formula in cell A3 to return a value of 56. Is this possible?
Thanks for any help.

Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
0 1 25 49 73 97 121 145 169 193 217 241 265
1 2 26 50 74 98 122 146 170 194 218 242 266
2 3 27 51 75 99 123 147 171 195 219 243 267
3 4 28 52 76 100 124 148 172 196 220 244 268
4 5 29 53 77 101 125 149 173 197 221 245 269
5 6 30 54 78 102 126 150 174 198 222 246 270
6 7 31 55 79 103 127 151 175 199 223 247 271
7 8 32 56 80 104 128 152 176 200 224 248 272

Reply to this Message

Don Guillett - 15 Aug 2006 23:15 GMT

Have a look in the help index for INDEX

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I need a formual that will give me a reult when I enter in the date and
>hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
[quoted text clipped - 10 lines]
> 6 7 31 55 79 103 127 151 175 199 223 247 271
> 7 8 32 56 80 104 128 152 176 200 224 248 272

Reply to this Message

Kevin Vaughn - 16 Aug 2006 00:13 GMT

With sample table in a1:m12, 3 in a12 and 7 in b12, this formula seemed to
work:

=INDEX($A$1:$M$9,MATCH(B12,$A$1:$A$9,0),MATCH(A12,$A$1:$M$1,0))

Signature

Kevin Vaughn

> I need a formual that will give me a reult when I enter in the date and
> hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
[quoted text clipped - 10 lines]
> 6 7 31 55 79 103 127 151 175 199 223 247 271
> 7 8 32 56 80 104 128 152 176 200 224 248 272

Reply to this Message