formulas

TPALJA

Im trying to calculate the remaining amount to be billed on a project based on the Job % of completion, factoring in the original contract amount, the deposit and remaining amount that is due

Michelle Choate 2

Maybe something like = ([Original Contract Amount]@row - Deposit@row) *(1-[Job % of Completion]@row)

Or if you want it based off the Original Contract Amount to find the total due, then remove the Deposit, it would be something like: = ([Original Contract Amount]@row *(1-[Job % of Completion]@row)) - Deposit@row

Michelle Choate 2

Maybe something like = ([Original Contract Amount]@row - Deposit@row) *(1-[Job % of Completion]@row)

Or if you want it based off the Original Contract Amount to find the total due, then remove the Deposit, it would be something like: = ([Original Contract Amount]@row *(1-[Job % of Completion]@row)) - Deposit@row