IF(AND function) help with multiple conditions

[brose99]

I am requesting some excel help from someone much smarter than I when it comes to excel IF(AND formulas).
(I already did a search before I posted my problem, and couldn't find what I was looking for.)

Here is my scenario:

A B C
1 (IF(AND fx) -7.5 -7.7
2 (IF(AND fx) -35.5 -14.4

The IF(AND fx) I want in column A

The argument I am trying to make for cell A1 is if C1 is less than -7, and B1 is greater than -10 but less than 10, then I would like a 1 to display in A1. If one or both of these conditions are not met, I would like for A1 to be blank.

In the example above, the IF(AND fx) should return a "1" in cell A1, and " " in cell B1.

Thanks in advance for your help!

[djapigo]

Hi brose99,

Try this formula...

=IF(AND(C1<-7,AND(B1>-10,B1<10)),1,"")

[alansidman]

Try this: =if(And(C1<-7,B1>-10,B1<10),1,"")

Alan

[TheExcelphile]

Both the solutions given will work fine.

If you want some reading material on IF and AND formulas, visit this site.

[brose99]

They both work! Thank you for the help and the quick replies!