P

#### puiuluipui

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:G1),"Expired",

INDEX(Sheet1!A1:G1,,MIN(IF(Sheet1!A1:G1>TODAY(),COLUMN(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!