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)



"OssieMac" wrote in message
...
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

"Darrel" wrote:

Project Total=600,000 (H35)
E36 F36 G36
H36
Current Payment Retainage Paid Running
balance
100,000.00 $10,000.00 90,000.00 510,000.00

=IF(H3650%*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
--
Darrel


"OssieMac" wrote:

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

"Darrel" wrote:

=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