IF(AND formula help

[brose99]

How do I write an IF(AND formula where if B1 is between 0.5 and -2.4, and D1 is between -0.7 and -4.5, then "1", "")

I know its a simple formula but every time I try it, i keep missing something. Thanks.

[mahju]

Try like this

Please Login or Register  to view this content.

Regards

[samba_ravi]

=if(and(b1>=-2.4,b1<=0.5,d1>=-4.5,d1<=-0.7),"1", "")

[Tony Valko]

=if(and(b1>=-2.4,b1<=0.5,d1>=-4.5,d1<=-0.7),"1", "")

Probably a good idea to not quote the number 1.

=IF(AND(B1>=-2.4,B1<=0.5,D1>=-4.5,D1<=-0.7),1,"")

[samba_ravi]

yaa you r right "Tony Valko, usually I don't do it, here I copied from the OPs post and edited

[brose99]

Got it. Thanks everybody!

[David A Coop]

Hi All,

Here is a different approach!

=AND(B1=MEDIAN(B1,0.5,-2.4),D1=MEDIAN(D1,-0.7,-4.5))*1

I picked this up on Chandoo website a few years ago and thought it quite clever.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.