| 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 |
| 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)
Threaded Mode
