Formula problem
The short answer is - your formula logic is incorrect. But your really need to explain - in words -
what you want to do rather than show what doesn't work - it doesn't work because the logic is
flawed, and we cannot figure out what you actually want to do from the flawed formula.
HTH,
Bernie
MS Excel MVP
"puiuluipui" wrote in message
...
Hi, i have a problem with this code:
=IF(NOT(SUMPRODUCT(--(Sheet1!A1:G1=TODAY()),--(Sheet2!A1:G1<""
))),"Please pay",
IF(COUNT(Sheet1!A1:G1),IF(TODAY()=MAX(Sheet1!A1:G 1),"Expired",
INDEX(Sheet1!A1:G1,,MIN(IF(Sheet1!A1:G1TODAY(),CO LUMN(Sheet1!A1:G1)))-COLUMN(Sheet1!A1:G1)+1)-TODAY()),""))
The "Expired" doesn't appear. This function does not work.
Can somebody help me with this?
Thanks!
|