In column A I have invoice date B I have "payment status" and C "actual payment date" and from B2 down I have the formula =IF(A2="","","unpaid") now this works, I also have column B on data val list so I can select "paid" from the drop down list once I've entered a date in column C. Is there a way to modify the formula so that it automatically changes to "paid" when a date is entered to C? I'm writing this from iPhone so apologies for any typos. Thanks in advance for any advice given.😃