Forum Discussion
Excel Formula Need help
Hi all, Complete newbie here. I'm trying to make a simple Customer / Order ledger. I have a cell (J4) for whether a customer has paid or not with Y or N value. What I want to do is say if that is Y ...
Hi Tauqeeracma,
Could you show how to adjust the formula that would automatically update the TO rather than just list the value. I need the TO to update as a customer pays then I will have a real time view of my Turn Over.
Many thanks
Pete
Could you show how to adjust the formula that would automatically update the TO rather than just list the value. I need the TO to update as a customer pays then I will have a real time view of my Turn Over.
Many thanks
Pete
Hi Peteasp
You can use the TABLE option to automatically update the TO column. I have modified the attached sample file.
Now, if you input Total Cost in G12 and Payment status in J12, the Turn Over column (L12) will be auto-updated.
Please let me know if it works for you.
Thanks
Tauqeer