If and value between two numbers

[Guest]

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

 

[Guest]

Cell M2 contains formula =IF(OR(A1=>J12,A1<G12),a1*100," ")
Replace the formula in M2 with this:
=IF(AND(A1>=J12,A1<G12),A1*100,"")

 

[Guest]

Happy me

That did the trick

Many many thanks

 

[Max]

welcome, glad it helped

 

[Zazzi Zazzi]

If value of C2 is between 4 and 16, Y and if not N.

 

[Pete_UK]

Try this:

=IF(AND(C2>=4,C2<=16),"Y","N")

Hope this helps.

Pete

 

[Kamen Frell]

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!