If blank cell

P

puiuluipui

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

If in sheet1!A1:G1, the last date is 01.08.2009, a date that has past, and
next cell is empty, the formula is not showing me "expired".I need the
formula to show me "expired" when it found the first blank cell.
EX:
A1 145/01.06.2009
B1 258/01.07.2009
C1 298/01.08.2009
D1 401/01.09.2009
E1

Cell E1 is empty.
If sheet2!D1 is empty, than the code to display "Please pay"
If sheet2!D1 has some numbers in it, than the code to display "expired"
because Sheet1!E1 is empty.
Can this be done?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula-different numbers entries 2
numbers instead if text 2
Formula problem 3
bookkeeping-payment confirmation 7
reverse pasting rows with alternate blank cells 0
if, then display message 1
Copying a split range 3
extract date from last cell 4

Top