IF greater than and less than

[jamiepullen]

i understand how to use the IF formulae if the subject is greater than or less than

eg =IF(B1>20,1,0) or =IF(B1<20,1,0)

But how would i write this if i wanted, for example to equal 1 if B1 is greater than 10 and less than 20?

[VBA Noob]

Try

=IF(AND(B1>10,B1<20),1,0)

VBA Noob

[jamiepullen]

thanks alot!!

[ChemistB]

Both the OR and the AND Functions preceed their arguments

Please Login or Register  to view this content.

So for your specific example

Please Login or Register  to view this content.

Make sense?

ChemistB

[daddylonglegs]

You can also return the desired result with this formula

=(B1>10)*(B1<20)

[jamiepullen]

often, i do things but dont know why with excel, i just know they work. Yes, that actually does make sense now, Regards, Jamie

[jamiepullen]

Both the OR and the AND Functions preceed their arguments

Please Login or Register  to view this content.

So for your specific example

Please Login or Register  to view this content.

Make sense?

ChemistB

So if i wrote something like =IF(OR(B1>10,B6>10),True,fALSE)

Would the cell = true if B1 is greater than 10, OR B6 greater than 10, otherwise false, or have i not quite got it?

Only reason i ask is that if this is the case, i would find the OR function quite useful

[jamiepullen]

second thoughts, why am i asking! i will open up a sheet and have a go!

[jamiepullen]

yes it does, gotta stop asking for help before i have even tried!!

learned 2 things here,

1/ how 'or' and 'and' work
2/ not to ask stupid questions without thinking!!