Log In
Register
Home
June 25, 2016
Offline
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,
June 25, 2016
Offline
Hi Mynda could you help?
November 8, 2013
Offline
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
June 25, 2016
Offline
Thanks Catalin, i have sent my file to mail my excel online training hub coz i cant upload here.
October 5, 2010
Offline
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
June 25, 2016
Offline
Thanks,Phil
I sent to you by mail please kindly check and correct
Regards
July 16, 2010
Offline
Here is Raths' file he sent via email.
VIP
Trusted Members
June 25, 2016
Offline
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
June 25, 2016
Offline
Thanks sunny,E35:G35 is just criteria it means if motor series 2016 rental cost $18,repair 15,oil 11 and so on
I just want you check my formula wrong or right as I don't use round or not round
Hope you see
VIP
Trusted Members
June 25, 2016
Offline
Sorry, I forgot to mention =SUMIF(B5:B21,O25,P5:P21) where O25 in your year e.g. 2014.
June 25, 2016
Offline
Sunny, I don't want to sum by year,i want you to check column N and O I see difference amount as I don't round and round.in practice I want 2 decimals.in column H as I round it is wrong in column I for value
VIP
Trusted Members
June 25, 2016
Offline
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.
June 25, 2016
Offline
Total amount received I Cal already Cell P22.the problem is col total repair per Mon and total oil per month in each cell I need to ask what difference if use round and not round.note I need only 2 decimals
1 Guest(s)
