Issue comparing 2 ranges and giving a result with a formula

[Jmoz092]

I thought this would be a pretty straight forward formula to create, but I'm not getting the result that I intended.

I have a few dozen check boxes on a worksheet(Sheet1). I have their values displayed in cells on a different worksheet(Sheet6).

I've transposed the values on Sheet6 to Sheet1 (for other reasons) and in the column next to those values (TRUE or FALSE), I have a column with a countA function. It is counting a range of 5 cells in a column and displaying the number of non-blank cells. This is working fine.

Now, in the next column, I want to compare the TRUE/FALSE column to the countA column for a result...either "Good" or "Bad".

If the first column has "TRUE" and the next column is >0, I want to return "Good".
If the first column is "TRUE" and the next column is 0, I want to return "Bad".
If the first column is "FALSE", I want to return "Bad"

I tried this with if(and) formulae also, but it wasn't working with that either. Is this a problem with referencing the value of a check box in a cell's formula??

Any help is much appreciated, as always.

 

[Jmoz092]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CheckBox Value[/TD]
[TD]Range CountA Value[/TD]
[TD]Good or Bad[/TD]
[/TR]
[TR]
[TD]TRUE[/TD]
[TD]1[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]TRUE[/TD]
[TD]0[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]FALSE[/TD]
[TD]0[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]FALSE[/TD]
[TD]1[/TD]
[TD]Bad[/TD]
[/TR]
</tbody>[/TABLE]


Something like this. How can I put this into a formula?

 

[steve the fish]

Try:

=IF(AND(A1<>"",B1<>""),IF(OR(A1=FALSE,AND(A1=TRUE,B1=0)),"Bad",IF(AND(A1=TRUE,B1>0),"Good","No result")),"")

 

[Jmoz092]

That did it. I feel like such an idiot for not nesting the conditions far enough, that was the issue. Thank you very much Steve!!