Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I think I posted this in the wrong place at first...
I'm not really too swift with Excel, so bear with me, but what I'm trying to do is something like: if A1 is one through five than B1 displays 7 if A1 is six through 10 than B1 displays 8 if A1 is 11 through 13 than B1 displays 10 if A1 is 14 through 17 than B1 displays 12 if A1 is 18 through 20 than B1 displays 15 if A1 is 21 than B1 displays 16 if A1 is 22 than B1 displays 17 if A1 is 23 than B1 displays 18 etc Can anyone help me or tell me what this operation is called? Or share a formula that I can copy and paste. I think I accidentally posted this on the Access boards :( And they were very helpful, but nothing worked.. hehe Thanks |