I have Contracts from Contractors that receive scheduled payments (25% 50% 75% 100%) for the job. Sometimes the contract amount is increased (even after a payment or two is received). My SIMPLE formula changes payments already sent but they should remain static. Someone sent me this that (I believe) is on the right track but I don't understand it and am a little confused as to what is in the H Column and what the D Column is referencing.
This may be oversimplifying the problem but basically functions are volitile
ie they will recalculate every time that it precedents change. You
thereforte have to have different precedents for each formula:
in G1:G4 I put 25%, 50%, 75% & 100% respectively. Enter the contract value
as it increases in H1:H4.
then in the payments cells:
1st Payment:
=IF(H1,H1*G1,"")
2nd Payment:
=IF(H2,H2*G2-D6,"")
3rd Payment:
=IF(H3,H3*G3-SUM($D$6:D7),"")
Full Payment:
=IF(H4,H4*G4-SUM($D$6:D8),"")
Any Help would be appreciated....Thanks!
Steve