IF and AND

[equalee]

I'm sure there's a simple answer to this...

I need to do the following:

From C1:
If A1 is greater than B1 and A1 and B1 are each <20, return value "+" to C1
If A1 is greater than B1 and A1 and B1 are each >80, return value "-" to C1

I've been trying to use IF and AND, but keep returning unexpected values

I mapped it out like this on paper:

=IF(AND(N5<20,O5<20),IF(N5>O5),"+",IF(AND(N5>80,O5>80)IF(N5>O5),"-",""),"")

But it doesn't work.

Any thoughts?

Any assistance would be great, I've been spending quite some time on this.

[zbor]

This is duplicated post:

http://www.excelforum.com/excel-prog...and-issue.html