AND/IF Conditional Rules

[imperium1980]

Hi all, hopefully someone can help me as I'm going round in circles trying to get this to work as I want.

I have 2 columns (A and B) of data side by side, some values positive, some negative. I need a formula in Column C that will compare the first 2 columns and give me a text output based on this. I need the following conditions:
1. If A is positive and B is negative then return "Good"
2. If A is positive and B is positive then return "Bad"
3. If A is negative and B is positive return "Good"
4. If A is negative and B is negative then return "Bad"

I can only seem to get half these conditions working with IF/AND/OR etc. Even if it had to be split into 2 columns, one for the "Good" and one for "Bad" I could live with it.

Any help greatly appreciated.

Regards,
Neil

 

[VoG]

Try

=IF(SIGN(A1)=SIGN(B1),"Bad","Good")

 

[rickbisselink]

Does

=IF(A1*B1<0,"Good","Bad")

give you what you want?


Rick

 

[imperium1980]

Try

=IF(SIGN(A1)=SIGN(B1),"Bad","Good")

This works! Never used SIGN before, thanks so much for your help. Saved me a headache.

Best regards,
Neil