Function to fill in Amount when date is added to another cell

New Contributor



I am working on an invoice spread sheet. The outcome I am trying to achieve is when the PAID date is entered to a cell that it copies the Billed amount from another cell. 


It will show a current outstanding balance at the end. 

2 Replies


Hard to say without knowing the setup. But perhaps:

Let's say the billed amount is in cell B2, and the date will be entered in cell D2. You want to see the billed amount in cell O2 when the date is entered.

In O2:

=IF(D2="", "", B2)

That worked thank you so much for the quick and helpful response.