

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,


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)
