Forum

Notifications
Clear all

Motor rental

15 Posts
5 Users
0 Reactions
245 Views
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

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, 

 
Posted : 19/08/2016 12:48 pm
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

Hi Mynda could you help?

 
Posted : 23/08/2016 9:59 pm
(@catalinb)
Posts: 1937
Member Admin
 

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.

 

1-1.jpg

 

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

 
Posted : 24/08/2016 4:23 am
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

Thanks Catalin, i have sent my file to mail my excel online training hub coz i cant upload here.

 
Posted : 24/08/2016 8:40 am
Philip Treacy
(@philipt)
Posts: 1633
Member Admin
 

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

 
Posted : 25/08/2016 12:45 am
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

Thanks,Phil

I sent to you by mail please kindly check and correct 

Regards 

 
Posted : 25/08/2016 3:18 am
(@mynda)
Posts: 4764
Member Admin
 

Here is Raths' file he sent via email.

 
Posted : 25/08/2016 8:12 am
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 25/08/2016 10:37 am
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

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

 
Posted : 25/08/2016 8:49 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Sorry, I forgot to mention =SUMIF(B5:B21,O25,P5:P21) where O25 in your year e.g. 2014.

 
Posted : 25/08/2016 9:15 pm
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

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 

 
Posted : 25/08/2016 9:45 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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.

 
Posted : 25/08/2016 10:47 pm
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

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

 
Posted : 26/08/2016 12:59 am
(@sunnykow)
Posts: 1417
Noble Member
 

From your data, there are no differences whether you round them or not.

Normally I would round if the formula involves a division.

 
Posted : 26/08/2016 9:35 pm
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

Thanks, sunny 

 
Posted : 27/08/2016 5:32 am
Share: