Basic excel question

[conorm]

Hi I'm trying to implement a formula where I can say if 'B' is greater than or equal to 'A' but less than or equal to '10.0' then BET otherwise do nothing, but can't quite seem to figure it out. This is what I have so far but it isn't working, what would you change?

=IF(A1<=B1<=10.0, "LAY", "")

[Euler]

A quick way is to nest the IF statement

IF(A<=B,if(B<=10,dothis,elsedothis),elsedothis)

[conorm]

Thanks again Euler, I've put it in and it seems to work in practice mode, I'll test it properly later.

Conor

[olligeorge]

Another way would be to enter:

=If(and(A1<=B1,B1<=10),"LAY","")

Hope this helps.