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 ...
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!