IF Function Formula

[Susan Metheny]

I'm stuck on this formula:

=IF((AND($E19<=$C19, $H19>1)"Good Job"),IF($E19>$C19,"Too Much Time","Poor Quality"))

I've tried entering it a million different ways and the best I can get is a #VALUE error. Could someone help me correct it and also understand what I've done wrong?

Thank you!

[#2]

Does any of those cellls in your formula already contain #Value perhaps?

[#3]

No, the cells were blank before I entered the formula. The cells in the formula itself are all numerical values and don't contain formulas themselves.

[#4]

Susan,

your formula cannot be put in a cell. It's full of errors.

Probably:

=IF(AND($E19<=$C19,$H19>1),"Good Job",IF($E19>$C19,"Too Much Time","Poor Quality")) 
=CHOOSE(($E19<=$C19)*2+($H19>1)+1,"Too Much Time","Too Much Time","Poor Quality","Good Job") 

[#5]

According to my instructions, it has to be written as an IF function. I know I'm doing it incorrectly, but I don't know how to fix it. Could you help me correct it so that I understand what I've done wrong? Thank you!