=IF((H36)300000,E36*1.1-E36,0)

The above sort of works, but you have to type in half of the total cost
600,000
I would like:
IF((Current Payment)50% of (Project total)then(10% retainage)<50% no
retainage.
Project Total=600,000 (H36)

Current Payment Retainage Paid Running balance
100,000.00 $10,000.00 90,000.00 510,000.00

Thanks! I hope this makes sence

Darrel


--
Darrel