June 25, 2016
Hi expert,
I have rent motor by series i. e 2016, 2015, 2014........, by contract if series of motor in current year so rental fee $18, repair $15 nd oil $14, if less than 1 year rental $14, repair $15 nd oil $13. If less than 2 years rental $13, repair$15 nd oil $12. If less than 3 years rental $12, repair $15, oil $10, assumption for working days 22 days.
Query if i rent motor series 2014 how can i calculate total amount received if his actual working days only 19 days, withholding tax is 10% on rental?
Sorry i have no excel file yet
Please kindly help by separating rental, repair , oil nd total amount?
Thanks in advance
Regards,
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi rathanak,
Whenever there is no answer, this may mean that the subject is not clear enough, it's a good idea to come up with more details and an example file, with a manual result based on the scenario described. A clear description of the problem, with sample file and with a manual example of the desired result will always get faster responses.
See the attached file. You've seen and received similar solutions before, so I guess you should be able to make the adjustments if needed.
L.E: The file fails to upload, you have an image of the formulas, just type them on your file and adjust the references.
Cheers,
Catalin
October 5, 2010
Hi Rathanak,
I haven't seen any email from you arrive.
What browser are you using? Please try a different one and see if you can attach the workbook with that. I have no issue attaching documents to this topic.
If you still can't attach a file, please open a Helpdesk ticket.
Regards
Phil
VIP
Trusted Members
June 25, 2016
Hi rathanak
The formulas in your file seems inconsistent, especially columns H, N and O. Even the values in E35:G39 is not what you described in post #1.
From your question I can only take a guess that you wanted to sum column P (Total Amount Received) for year 2014 in column B (Series).
If that is what you want, then you can try =SUMIF(B5:B21,O25,P5:P21)
Sunny
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi rathanak your post did require for the total received in 2014.
"Query if i rent motor series 2014 how can i calculate total amount received if his actual working days only 19 days, withholding tax is 10% on rental? "
I don't quite understand your question. Please give an example of what you want.
1 Guest(s)