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 then the TO cell (L4) should be the amount total of cell total cost (G4) and continue to add up for every total cost (G4) entered after. Obviously if the customer paid value is 'N' then the TO should remain the same value.

Any help greatly appreciated

Thanks in advance

Pete

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

Resources