formula for less than or equal to

[TonyW1234]

Hi,

Please could anyone advise how to add a formula to work out if a value is > or equal to a number using an or statement, I currently have this formula but it doesnt seem to work

=IF(OR(Y2>0<=1185),5,IF(OR(Y2>1185<=4242),7,0))
thanks

Tony

 

[Andrew Poulsom]

You need to test each time:

=IF(OR(Y2>0,Y2<=1185),5,IF(OR(Y2>1185,Y2<=4242),7,0))

 

[Lewiy]

Try this:

=IF(OR(Y2>0,Y2<=1185),5,IF(OR(Y2>1185,Y2<=4242),7,0))

 

[TonyW1234]

thanks a lot for that, just what i needed

Tony

 

[Peter_SSs]

thanks a lot for that, just what i needed

Tony

Hmmm, I'm wondering just what it was you did need - the answer 5 always?

I can't think of any number you could put in Y2 that would fail the first test..
OR(Y2>0,Y2<=1185)

I'm just guessing, but maybe you really wanted this?

=IF(AND(Y2>0,Y2<=1185),5,IF(AND(Y2>1185,Y2<=4242),7,0))