Formula Help!!!

[cara16anna]

I'm trying to write a formula that will return true if a cell value falls inbetween two numbers and false if it doesn't.

Does Excel not recognize greater than and less than symbols?

Any help would be greatly appreciated!!!

Thanks

 

[gaz_chops]

Try putting the value in a cell then reference the cell

 

[Pekkavee]

Put a space in front of your ">" sign and "<" sign
so your formula comes through correctly to this forum.

There is some problem with these signs.

Pekka

 

[cara16anna]

I am referencing a cell...

IF(0.35<AB3<0.46,1.5,AB3)

 

[Seti]

You need to use AND in this case. Try this:

 IF(AND(0.35<AB3,AB3<0.46),1.5,AB3)

 

[cara16anna]

THANK YOU!!!

Can you explain why I need to use AND in this case?

 

[cara16anna]

Never mind...I see.

THANKS AGAIN!