% Retainage info ---Sorry DUH!
 

=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

% Retainage info ---Sorry DUH!
 

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

% Retainage info ---Sorry DUH!
 

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

% Retainage info ---Sorry DUH!
 

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

% Retainage info ---Sorry DUH!
 

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

% Retainage info ---Sorry DUH!
 

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!
--
Darrel


"Bob Phillips" wrote:

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