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