Multiple Condition IF Formula - Help Needed!

Hi. I have a conundrum which hopefully someone can help me with...

For a bit of background, in my office we have three targets or goals, "WRAP", "In vs. Out" and "Inbound per hour". We set weekly 'goals' and obviously want WRAP to be less than our goal and Inbound per Hour and In vs. Out to be higher than our goals and I need a way of recording whether the goals are met on a weekly basis and would like to automate this as much as possible.

I need a formula to solve the following:

Column A = Goal (type), B = Goal (figure) C = Actual

In Column D I want:

If A1 is "WRAP" and C1 is less than B1, "Yes", "No" BUT if A1 is not "WRAP", and C1 is greater than B1, "Yes", "No".

Does this make sense?

Thanks,

Paul

Hi,

Could you kindly share a sample workbook so as to get more clarity on your issue.
And esp related to goals.

Thank you. The above formula worked wonderfully. Really grateful