Dear TOM,

Thanks for your help and i really appreciate the way you put an effor
to answer all needy people like me. I really admire your parents an
teachers who gave you such manners and teachings, to never say NO t
anybody and keep spreading smiles to all. I am impressed. Please kee
this thing going and i tell you what you will end up gaining more an
more. You are doing a great job. may GOD keep you moving with success
(AMIN)

Thanks for sending me the solution, but to tell you the good news tha
i solved that query by myself, they solution that you gave me wa
showing the results in a message box, but what i need was the total o
res and res1 in cell lets say C3. and i did it by declaring an othe
variant named as tak and added res and res1 values in this variable
later on showed it on the cell address C3. pretty simple but it worked
your solution is excellent and i am thinking of using it in later stag
of this program.

I have a formula query, i need to check more than 10 conditions, i kno
it can be done by usinf AND/ OR But i am unable to figure out how.
have more than 10 conditions to check and all return same cell value i
the cell. for example if cell c3 = 84 and cell d3 = 21, then displa
message GOOD, else OK. if c3= 84 and cell d3 = 22 then display BAD
else OK. and the conditions keep on going on and on. Please help m
out.


Regards and Best wishes,


darn

--
Message posted from http://www.ExcelForum.com