Need Help writing a formula for personal bills

LEROYHOP

New Member
Joined
Dec 29, 2005
Messages
3
I trying to set up a formula were I will put in the due dates of my bills and within 15 days of the due date I wont the formular to post the text Due. Once I pay the bill i will put the amount i paid in the amount paid cell once i do that I wont the Due to change to Paid.

This is what i have so far =IF(E7,"Paid","DUE") but the Due is always there. Also i have it where The due is red and the paid is grenn With the help of conditional formating.

Just need help with making it say due 15 days prior and paid when i put the amount paid.

Due Date 15-Jan-06 Due Date 15-Jan-06
Amount Due $149.00 Amount Due $149.00
Amount Paid Amount Paid $149.00
Balance $169.00 Balance $20.00
DUE Paid
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Peter100

Well-known Member
Joined
Apr 21, 2002
Messages
765
try
=IF(A3>0,"PAID",IF(B3-TODAY()<15,"DUE",""))

where column A holds the paid amount and column B is the due date
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,486
Members
412,669
Latest member
nickyon1
Top