Check if formula

Hi Experts

Not sure why the following if formula is not giving the correct answer:
Formula:-
=A3/IF(ISERR(FIND("contractor",K3)),7,8)

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.

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

=A3/IF(ISERR(SEARCH("contractor",K3)),7,8)
0
 
route217Author Commented:
Ok let me re test. Thanks for the feedback.
0
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.