View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
craig@help[_3_] craig@help[_3_] is offline
external usenet poster
 
Posts: 1
Default Complicated work! Any idea??


Ken Johnson Wrote:
Hi Craig,

Will this work"?

In Duration & Defect!D4...

=IF(AND(ISNUMBER(Master!$K$5),ISNUMBER(Master!$T$5 )),Master!$K$5+Master!$T$5,"")


In Duration & Defect!H4...

=IF(AND(ISNUMBER(Master!$L$5),ISNUMBER(Master!$U$5 )),Master!$L$5+Master!$U$5,"")


In Duration & Defect!J4...

=IF(AND(ISNUMBER(Master!$K$5),NOT(ISNUMBER(Master! $T$5))),Master!$K$5,"")

In Duration & Defect!N4...

=IF(AND(ISNUMBER(Master!$L$5),NOT(ISNUMBER(Master! $U$5))),Master!$L$5,"")

In Duration & Defect!P4...

=IF(AND(NOT(ISNUMBER(Master!$K$5)),ISNUMBER(Master !$T$5)),Master!$T$5,"")

In Duration & Defect!T4...

=IF(AND(NOT(ISNUMBER(Master!$K$5)),ISNUMBER(Master !$T$5)),Master!$U$5,"")


Hope I didn't stuff-up anywhere, it wasn't easy keeping track of what
goes where!

Ken Johnson


Hi Ken,

No you haven't stuff-up at all!!;)

I have tried what you have given me and it worked like a dream!!

One more thing, if it is possible, on the defect parts, the max numbe
is 10 and min number is 1. so if we have kitchen and bathroom bot
input 10, then it will add up 20, how do we get round that?

If unable, don;t worry, i see what i can do, but many thanks again.

Craig:

--
craig@hel
-----------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...fo&userid=3620
View this thread: http://www.excelforum.com/showthread.php?threadid=56316