We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Check if formula

route217
route217 asked
on
Medium Priority
295 Views
Last Modified: 2012-05-11
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.

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
route217Junior

Author

Commented:
Ok let me re test. Thanks for the feedback.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.