HELP - easy q for those well versed in excel

[Machiavelli]

So, my situation is as such:

I'm sure I need to use the IF formula, however not quite certain whether to use and/or.

This is what I want to do:

IF the value of say A1 is less than B1 but greater than C1 then the answer should be the data I've input in say D1.

I have 6 References, say A1:A6 and I want to, if possible, use one single formula which does the trick.

Should need be to clarify anything I've typed, kindly ask me to elaborate.

Edit: I'd believe for anyone to provide a sufficient answer they'd need specific numbers, if you like whoever, feel free to conjure up some random numbers.

 

[steve the fish]

Hi. What about the FALSE answer? ie A1 is not less than B1 and/or A1 is not greater than C1?

=IF(AND(A1 < B1,A1 > C1),D1,"")

 

[Machiavelli]

Apologies for not wording myself more correctly.

Let's try something fictional.

It has already been decided that if membership amount from each city/organization is so and so, then so and so many seats are reserved for the representatives of said city/organization.

For instance:

Chicago oRG 90,000 members

Pre-set value of members above 80,000 and below 100,000 = 18 representatives

There is a cell containing the info for the amount of membership an organization has in a given city, in this case Chicago (and possibly many others)

The cell info is thus such, for order's sake:

Cell A1: 90,000

CELL B1: Minimum 80,000
CELL B2: Maximum 100,000

Cell D1: 18

Is it slightly easier to follow now? I am trying to conjure a formula which probably uses IF/AND/OR maybe even MIN/MAX, idk.

The numbers are determined. The formula needs to firstly Control whether a set number is between a lowest set digit and a highest set max limit. If this is the case, then it should refer to a cell which contains the information on how many representatives are allowed for an organization/city that has a membership tally between so and so amount. In this case the set number is 18.

Everything is determined, basically. I just need the correct formula.

 

[RoryA]

You still didn't really address Steve's question - what should the answer be if the number is not within the parameters specified?

 

[SpillerBD]

The Fish has it right for the way you have worded your question.
But lets say want to calculate the number of representatives for more than one D1 value. Then you would use a VLOOKUP on a sorted table.
See vlookup a number from a range - Microsoft Community
You don't need to use any sheet space for the table using a defined range. Note example with table defined in formula with "{ }"