LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Need help with formula for expressing multiple greater/less than

I am trying to construct a formula that will be based on the result of
an adjoining cell. I need to point to specific cell depending on what
the number is in that adjoining cell.

So for example:

If D1 = 0 or 1 - point to B21
If D1 = 2, 3, 4, or 5 - point to B22
If D1 = 6,7,8,9, or 10 - point to B23

and so on...

Rather than listing all of those variables, I know I should be able to
write it as equal to/greater than, but less than. I just don't know
how to express as a formula.

Thanks in advance for your help.
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to determine if multiple dates are "greater than" one date kg82 Excel Worksheet Functions 3 October 20th 08 11:09 PM
Expressing a number in words Karen Crozier Excel Discussion (Misc queries) 3 July 31st 07 03:42 PM
Expressing a number in words Mike D Excel Worksheet Functions 2 December 14th 06 06:43 PM
Expressing percentages in Excel John Hodgson Excel Discussion (Misc queries) 1 August 30th 06 12:09 AM
expressing minutes negatively DJ Excel Discussion (Misc queries) 3 March 14th 06 06:07 PM


All times are GMT +1. The time now is 02:33 AM.

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

About Us

"It's about Microsoft Excel"