% Retainage info ---Sorry DUH!

[Guest]

=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

 

[Guest]

Hi Darrel,

I can't really follow what you are trying to do because I am not sure that
the first H36 in your formula is correct. But since you say it works but you
have to type in half the total cost (300,000) then you can get half the total
cost by multiplying by 0.5 which is 50%.

=IF((H36)>H36*.5,E36*1.1-E36,0)

Regards,

OssieMac

 

[Guest]

Project Total=600,000 (H35)
=IF(H36>50%*H35,10%*E36,0) This appears to work, would using .5 be better?

Sorry first time on here I hust figured out how to reply without re-posting.

Thanks

 

[Guest]

50% or .5 same thing. Obviously I did not explain very well. Instead of
saying multiplying by 0.5 which is 50%, I should have said by 0.5 or 50%.

Regards,

OssieMac

 

[Bob Phillips]

If someone doesn't realise that 0.5 is the same as 50%, they will struggle
with Excel formulas regardless.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

I did not think you could use % . I thought you had to use .5
It seems that a few years ago excel woul not accept % in the formula. Maybe
I was just doing it wrong back then and kept some old habits.

Thanks!