LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steve
 
Posts: n/a
Default Can Someone Help Me

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"