Check if formula

Hi Experts

Not sure why the following if formula is not giving the correct answer:

The return I want is if the resource type in cell K3 is contractor then "divide" the total hrs in cell A3 by 8, otherwise divide by 7.

Who is Participating?
Rory ArchibaldCommented:
Perhaps it's just that FIND is case sensitive:

route217Author Commented:
Ok let me re test. Thanks for the feedback.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.