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,
Hi Mynda could you help?
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
Thanks Catalin, i have sent my file to mail my excel online training hub coz i cant upload here.
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
Thanks,Phil
I sent to you by mail please kindly check and correct
Regards
Here is Raths' file he sent via email.
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
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
Sorry, I forgot to mention =SUMIF(B5:B21,O25,P5:P21) where O25 in your year e.g. 2014.
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
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.
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
From your data, there are no differences whether you round them or not.
Normally I would round if the formula involves a division.
Thanks, sunny