Forum Discussion

Peteasp's avatar
Peteasp
Copper Contributor
Nov 10, 2022

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 ...
Formulas and Functions
  • Peteasp's avatar
    Peteasp
    Copper Contributor
    Nov 11, 2022
    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
    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor
      Nov 12, 2022

      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

  • Peteasp's avatar
    Peteasp
    Copper Contributor
    Nov 11, 2022

    tauqeeracma Thats perfect. What I was doing was not to far away so thank you very much.

    Pete