lucas
04-10-2005, 10:32 AM
I downloaded an invoice book posted by Jonske I think. I have found it useful but want to make a few improvements. It not only prints an invoice, it logs it and keeps a record. On the record sheet which is named "Sales", there is a column-(I) for overdue accounts. I am using a nested if statement in that column which refers to a date in column H.
What I want the formula to do is...
leave the cell blank if the account is not overdue...
Put the word yes in the cell if it is overdue...
leave the cell blank if the referenced cell (in column H) is blank.
I have gotten two out of three things accomplished. I just cannot get it to stay blank if there is no data in column H.
Here is the formula I am trying:
=IF(H2<=TODAY(),"YES",IF(H2>=TODAY(),"", IF(H2="","","")))
the workbook is attached in case I wasn't able to make my problem clear. Hoping someone can help me with this.
ps I changed the action on the print button to printpreview for testing so it will not print the invoice if you click the button, only preview.
What I want the formula to do is...
leave the cell blank if the account is not overdue...
Put the word yes in the cell if it is overdue...
leave the cell blank if the referenced cell (in column H) is blank.
I have gotten two out of three things accomplished. I just cannot get it to stay blank if there is no data in column H.
Here is the formula I am trying:
=IF(H2<=TODAY(),"YES",IF(H2>=TODAY(),"", IF(H2="","","")))
the workbook is attached in case I wasn't able to make my problem clear. Hoping someone can help me with this.
ps I changed the action on the print button to printpreview for testing so it will not print the invoice if you click the button, only preview.