Help with creating a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1719915%22%20slang%3D%22en-US%22%3EHelp%20with%20creating%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1719915%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%20I%20am%20trying%20to%20make%20a%20spreadsheet%20that%20shows%20an%20annual%20contract%20amount%20we%20are%20supposed%20to%20get%20paid.%20I'd%20like%20to%20be%20able%20to%20enter%20payments%20each%20month%20made%20by%20the%20customer%20and%20see%20the%20%22remaining%20contract%22%20amount%20go%20down%20in%20correspondence%20with%20this.%20They%20pay%20a%20different%20amount%20every%20month%20so%20it%20gets%20confusing.%20I%20can't%20figure%20out%20how%20to%20set%20this%20up.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1719915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1721693%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20with%20creating%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721693%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811688%22%20target%3D%22_blank%22%3E%40VanessaDavis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20small%20example%20in%20the%20quick%2C%20as%20sales%20forecast%20might%20see%2C%20in%20the%20simplified%20way.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMost%20is%20self-explanatory%20when%20dealing%20with%20sales.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all! I am trying to make a spreadsheet that shows an annual contract amount we are supposed to get paid. I'd like to be able to enter payments each month made by the customer and see the "remaining contract" amount go down in correspondence with this. They pay a different amount every month so it gets confusing. I can't figure out how to set this up. Thanks!

1 Reply
Highlighted

@VanessaDavis 

 

Here is a small example in the quick, as sales forecast might see, in the simplified way.

Most belief is self explanatory when dealing with sales.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.