Forum Discussion
IF Function Formula
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!
4 Replies
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")
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!
- Does any of those cellls in your formula already contain #Value perhaps?
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.
