Nested testing

Sir
greetings for the day!

Currntly i am using formula

Please Login or Register  to view this content.

but i am not getting the desired result

what i want from this nested testing

if my cell h12 is "check this entry" or cell k12=102 or k12=103 or k12=112 or k12="*" then value of the cell in which i have feeded this formula should be "check this entry" and if h12 is "ok" but either of cells k12 should not =102 or k12 should not=103 or k12 should not=112 or k12 should not="*" then the value of the formula cell should be "ok"

and if h12 is "ok" but either of cells k12 =102 or k12 =103 or k12 =112 or k12 ="*" then the value of the formula cell should be "check this entry"

one more thing sir

it all should be execeuted only when value(d12)>0 other wise formula cell should return as blank if value(d12) is not greater than zero

plz help me sir

Sir

my sample sheet have so much of confidential data ,so it will be diff for me to upload orignal..but if u try it sir...it can be tested by creating cell h, k, d with dummy data

plz help

Sir

my cell k12 will have either 101,103,112,* and h12 can be either "ok" or "check this entry"

but my ultimate ans cell is g12 which check if k12 is none of the above and h12 is not "check this entry"

then g12 ok

other wise if either of condition is ther g12 "check this entry"

but all should be exicuted only when d12>0

Sir

m3:m7

does not have any value in my sheet

My nested testing should executed when d12>0 plus it should depend on two cells value that is h12 and k12

plz help in this manner sir

Sir

sample for understanding the cases is attached with diff cases,plz see

formula compatible with 2003 2007 excel both plz

i will strech/drag the formula in column g

One thing i left to include in my sample is cell value in correponding column d must be greater than zero for the said results in sample ,other wise result column g should remain blank

Plz see attchment

Every thing is ok with this but one prob

ok should come only when all the h and g column conditions are follwed and nothing is there that means

h3 is not="check this entry",k3 is not="*",k3 is not={102,103,112, any thing

and h3 is ok

then only g3 should be ok

I mean for g3 "ok will only result when none of the testing comes true and h3 is "ok"

then only g3 should come as "ok"

Earlier one was better than this,only one prob was with it,that if h3 is ok and else conditions are not true then g3 should be "ok"

if(and(or(h3="ok"),or(k3="*",k3={102,103,112,"any thing"})),"
IN THIS PART (k3 SHOULD NOT="*",k3 SHOULD NOT={102,103,112,"any thing"})),"
THEN H3 SHOULD BE "OK"

Anybody....

I am confused how to use nested testing for should not equal to check as above are hampering...

This is absolutely ok except one condition is left

what i want is "ok" should come in result column only when h3="ok" and k3 not=102 nor 103 nor 112 nor 112 nor *

that means ok should also be conditional and should come when above conditions got satisfied

I have uploaded the same...plz see

No problem sir....you all have taken my post ,and attempted and helped me..

Thanks to all of you

i think there would be no solution on "not equal to situations"

so i will think for another alternative and now i am closing this post but anyways many many thanks to all of you....

Excel forum has always helped me...