condition formula result from depends upon 3 cell values with conditions

Dear experts

Here I Tried One Formula But It Could Nt Work Properly I Want Improve This Formula With Multiple Conditions.
Here Conditions ,If Zone Is ""A"", If Business Is ""Nd"", If Total Hours Less Than =1 I want result Is "Hit Target" Or If Total Hours More Than 1 I want result Is "Miss Target".
Other Conditions If Zone Is Other Than ""A"" If(B,C,D,), (Or )If Business Is Other Than ""ND
If(2BD,3BD,4BD,5BD) If Total Hours Less Than 2 Hours Is Hit Target Or If Total Hours More Than 2 Hours Is Miss Target..........
Main One Conidition Is Calculate Total Days If Open Days Is Saturday - Sunday Should Not Be Include In Formula....Direct Calculate With Monday


please find the attachment...


thanks

Originally Posted by etaf

AND(A2<>"A",B2<>"ND",Hours<2) Hit Target
OR
AND( A2="A", B2="ND", hours<1) Hit target

These following two conditions are not needed , as if the condition above is not meet, then it must be a miss
AND(A2<>"A",B2<>"ND",Hours>2) miss target
OR
AND( A2="A", B2="ND", hours>1) Miss target


What happens if it is eqaul to 1 or 2 hours
Also not sure where you calculate the hours - as in your spreadsheet you have Days
do you mean days or hours ?
the formula is below and I have put Hours, instead of the cell , as not quite sure what you want

IF ( OR(AND(A2<>"A",B2<>"ND",Hours<2), AND( A2="A", B2="ND", hours<1)) , "Hit Target", "Miss Target")

You can just put F2 instead of hours, and let him decide whether it is hours or days.

Dude


It doesnt give expected result , i make clear what am i looking for ...

I calculate days From OPEN & CLOSE Dates So From Result of days.

If Zone is A and Business is ND if Caculate Days <= one day i want result "HIT TARGET"
IF ZONE IS A AND BUSINESS IS ND IF CALCAULTE DAYS MORE THAN ONE DAY I WANT RESULT "MISS TARGET"
IF ZONE IS OTHER THAN B,OR C,OR D IF BUSINESS IF 2BD,OR 3BD,OR 4BD,OR 5BD IF CALCUALTE DAYS LESS THAN EQUAL 2 I WANT RESULT "HIT TARGET" IF CALCUALTE HOURS MORE THAN 2 DAYS I WANT RESULT MISS TARGET

IF ZONE IS A AND BUSINESS IS IF 2BD,OR 3BD,OR 4BD,OR 5BD IF CALCUALTE DAYS LESS THAN EQUAL 2 I WANT RESULT "HIT TARGET" IF CALCUALTE HOURS MORE THAN 2 DAYS I WANT RESULT "MISS TARGET"

IF ZONE IS B,OR C,OR D BUSINESS IS ND IF CALCUALTE DAYS LESS THAN EQUAL 2 I WANT RESULT "HIT TARGET" IF CALCUALTE HOURS MORE THAN 2 DAYS I WANT RESULT "MISS TARGET"



I WANT FORMULA FOR THOSE CONDITION


PLS HELP ME...........................

any one help on this?