Formula problem
Hi puiuluipui,
From the original formula, :
IF(COUNT(Sheet1!A1:G1) - this logical test is not complete - the count
should equal, be greater than or less than something in order to proceed to
if this test is met, to check for the next test of
IF(TODAY()=MAX(Sheet1!A1:G1),"Expired"
=IF(NOT(SUMPRODUCT(--(Sheet1!A1:G1=TODAY()),--(Sheet2!A1:G1<""
))),"Please
pay",IF(COUNT(Sheet1!A1:G1),IF(TODAY()=MAX(Sheet1 !A1:G1),"Expired",INDEX(Sheet1!A1:G1,,MIN(IF(Sheet 1!A1:G1TODAY(),COLUMN(Sheet1!A1:G1)))-COLUMN(Sheet1!A1:G1)+1)-TODAY()),""))
--
If this post helps click Yes
---------------
Peggy Shepard
"puiuluipui" wrote:
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!
|