# Excel - If and value between two numbers

Asked By Mift on 19-Oct-07 09:30 AM
```Hi everyone,

Could someone help me with the following formula please?

Cell M1 contains formula =IF(A1<J12,(A1*100)," ")

What I need is if A1 is less than J12 then A1(*100) should show in the cell
but then

Cell M2 contains formula =IF(OR(A1=>J12,A1<G12),a1*100," ")

If A1 is greater than or equal to J12 but less than G12 then A1(*100) should
show in the cell

Hope this makes sense â€“ it is Friday afternoon here and brain cells are
firing extremely slowly ;-))

TIA

--
Mifty```

demechani replied on 19-Oct-07 09:49 AM
```Replace the formula in M2 with this:
=IF(AND(A1>=J12,A1<G12),A1*100,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---```
Mift replied on 19-Oct-07 10:06 AM
```Happy me :-)

That did the trick

Many many thanks
--
Mifty```
Max replied on 19-Oct-07 10:25 AM
```welcome, glad it helped
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---```
Zazzi Zazzi replied to Mift on 31-Aug-10 08:31 AM
`If value of C2 is between 4 and 16, Y and if not N.`
Pete_UK replied to Zazzi Zazzi on 31-Aug-10 09:30 AM
```Try this:

=3DIF(AND(C2>=3D4,C2<=3D16),"Y","N")

Hope this helps.

Pete```
Kamen Frell replied to Pete_UK on 03-Nov-10 09:21 AM
```What about checking columns.  I have IP addresses in column A and B and the location they are associated with in C:

1.1.1.1   1.1.1.254   city1

1.1.2.1   1.1.3.254   city2

1.5.1.1   1.5.3.254   city2

And so on.

I would like to take a list of IP addresses in column D and return what city the IP address in column E

1.1.2.1  = city1

1.5.2.2  = city2

Thanks!```