Feb 23 2018
09:37 AM
- last edited on
Jul 25 2018
11:09 AM
by
TechCommunityAP
Feb 23 2018
09:37 AM
- last edited on
Jul 25 2018
11:09 AM
by
TechCommunityAP
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!
Feb 23 2018 10:01 AM
Feb 23 2018 10:14 AM
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.
Feb 23 2018 10:15 AM
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")
Feb 23 2018 10:19 AM
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!