Oct 03 2022 05:08 AM
Hi,
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.
Oct 03 2022 05:17 AM
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)
Oct 03 2022 05:23 AM