if, then display message

P

puiuluipui

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:C1),"Expired",INDEX(Sheet1!A1:C1,,MIN(IF(Sheet1!A1:C1>TODAY(),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!
 
K

KC

try this
=IF(Sheet1!A1:C1="OP","integral",IF(NOT(SUMPRODUCT(--(Sheet1!A1:C1>=TODAY()),--(Sheet2!A1:G1<>""))),"Please
pay",IF(COUNT(Sheet1!A1:C1),IF(TODAY()>=MAX(Sheet1!A1:C1),"Expired",INDEX(Sheet1!A1:C1,,MIN(IF(Sheet1!A1:C1>TODAY(),COLUMN(Sheet1!A1:C1)))-COLUMN(Sheet1!A1:C1)+1)-TODAY()),"")))

-kc
*Click YES if this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top