I have a spread sheet for checks I receive from insurance for repairs on cars. they all come at different times
Colum D is the amount already paid
Colum E is the total amount due
Colum G is the total still due after checks have been received
Colum I is only occupied if customer has a deductable, which would subtract from the total due by the insurance company, which would also subtract from colum G for total still due. I have little experience with formulas
someone please help I need a formula that will take the total from colum E subtract from colum D and display the answer in colum G, but also subtract the deductable from colum I.
im tired of manually entering them. need it to be automativ
Example:
Customer. Paid. Balance. Due. Deductable
John Doe. $6,874. $10,773. $3,859. $1,000
help please
Bookmarks