View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default if, then display message

Hi, i have this code. It's working great. I need to modify a little bit this
code without alter this code. I need just to add one more thing:

{=IF(NOT(SUMPRODUCT(--(Sheet1!A1:C1=TODAY()),--(Sheet2!A1:G1<""))),"Please
pay",
IF(COUNT(Sheet1!A1:C1),IF(TODAY()=MAX(Sheet1!A1:C 1),"Expired",INDEX(Sheet1!A1:C1,,MIN(IF(Sheet1!A1: C1TODAY(),COLUMN(Sheet1!A1:C1)))-COLUMN(Sheet1!A1:C1)+1)-TODAY()),""))}

If in Sheet1!A1:C1 thecode finds "OP", then to display "integral"

Can this be done without to alter the code?
Thanks!