Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to display error message? | Excel Discussion (Misc queries) | |||
Can I use the IF function to display a message | Excel Worksheet Functions | |||
Display a message | Excel Worksheet Functions | |||
Display a message | Excel Worksheet Functions | |||
how to display an error message | Excel Worksheet Functions |