| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
% 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Begging one more time....Stuck on this....tracking Retainage % | Excel Worksheet Functions | |||
| Excel Function to track % of retainage | Excel Worksheet Functions | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
![Darrel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
