Thread: Complicated work! Any idea??
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Complicated work! Any idea??

Hi Craig,

Now I have stuffed it up!

Maximum defects is 10, not 20 so try...

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

Ken Johnson

Reply With QuoteReply With Quote