Hi,i need to manually enter in every cell in range a different number instead
of text. This formula is looking only for "OK". i need this formula to look
for different numbers.

=IF(NOT(SUMPRODUCT(--(Sheet1!A1:G1=TODAY()),--(Sheet2!A1:G1="OK"))),"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()),""))

EX
A1 145/01.01.2010
B1 258/01.02.2010
C1 298/01.03.2010
D1 401/01.04.2010
........

I need the formula to not contain a default number in it. I need the formula
to work if i enter a diferent number in a cell, each time. I don't want to
replace in formula "OK" with a number without quotes like you said. I need to
not put anything in formula instead of "OK". I need to cut somehow this part
with "OK" and the formula to work knowing that in every cell in range it will
be a different number each time.
The idea is that the formula to display "please pay" if there is an empty
cell. If the cell contain something(and it will contain numbers-different
numbers)than the formula to display result.
Sorry for my english.
Can this be done?
Thanks!