Begging one more time....Stuck on this....tracking Retainage %
Well, if you are so desparate for an answer it would help if you were
to give further details rather than just repeat what you posted
earlier - presumably you had no replies to that one?
Post details of your data layout, any formulae you currently use, what
you have tried already, what doesn't work. In particular, explain how
you cope with the retained amount at present, perhaps with a small
example, and what you would like to achieve ultimately.
Pete
On Nov 12, 11:31 pm, Darrel (donotspam) wrote:
I am trying to figure out a formula that will automatically figure retainage
for pay applications. We keep 10% retainage until we reach 50% of the total
construction cost. After that they are totally retained. My spreadsheet is
set of to retain 10% already. How can I have it check the total contracted
amount and quit removing 10% once retainage has reached 50% of the total
contract amount?
I am using excel 2003.
We usually get billed monthly for six months.
Thanks! Trying to finish this up so I can distribute in the AM
--
Darrel
|