1

Spreadsheet question (Read 105 times)


A Dance with Monkeys

    Spreadsheet question for all you spreadsheet peeps.

     

    I’d like to set up a spreadsheet with a running balance between two people, say George and Tom. In some cases George gives money to Tom, and in some cases Tom gives money to George. I could just do an simple running total where I code one person as + and another person as -, and have a positive balance imply George, and a negative balance imply George. I dunno, this seems a bit of a kluge.

     

    Is there a better way to do it where I could show a running Balance lean towards George or Tom, depending on who has given the most?

      Where A14 is the sum of George's contributions, B14 is the sum of Tom's contributions, A15 is the difference (George - Tom) and B15 =ABS(A15):

       

      =IF(A14>B14, CONCATENATE("Tom owes George ", TEXT(B15,"$0.00")), CONCATENATE("George owes Tom ", TEXT(B15,"$0.00")))

      Well at least someone here is making relevance to the subject.

        I suggest you stay out of it and let George and Tom handle their own debts.

        Runners run.


        A Dance with Monkeys

          Nice.

           

          How do I code the contributions to that the formula knows the contributor?


          just a simple cat

            Tom$50, George$50

             

             


            Will Crew for Beer

              This is a Beer Balance Sheet, isn't it?

              2014 Goal: Who the hell knows?


              A Dance with Monkeys

                Nice.

                 

                How do I code the contributions to that the formula knows the contributor?

                 

                Um, I don't know.  A database would be needed, I think.

                 

                Or, settle up after the drinking is done, so nobody cares.

                Well at least someone here is making relevance to the subject.


                A Dance with Monkeys

                  Ennay figured it out. I'll let her share the info, but it involves if then statements