Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate total rent charges
The below is my List of date effecting and the size code.
23/05/2007 1 X 20 28/05/2007 3 X 40 15/06/2007 3 X 40 15/06/2007 2 X 20 17/06/2007 1 X 20 18/06/2007 3 X 40 19/06/2007 4 X 20 20/06/2007 2 X 20 24/06/2007 6 X 20 27/06/2007 1 x 40 for which I am trying to get a formula to calculate the total rental charges to pay as on today by adding the prices depending on no. of days from effecting date. Both the Tables below are to be applied to find out the total rent charges. If the above Dates are in column A & sizes are in B can I get the total amount in C? RENTAL CHARGES- DAYS 1 x 20 1 x 40 8 to 17 Days 19.00 38.00 18 to 32 Days 24.00 43.00 33 Days & above 30.00 48.00 SPACE RENT 8. to 14 Days 35.00 70.00 15 Days & above 70.00 140.00 Anybody can please help me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate total rent charges
Please e-mail me at:
toppers <at NOSPAMjohntopley.fsnet.co.uk and I will send a sample solution. Can you also provide answers to the following, assuming TODAY = 07/07/07, so I can check my results: 23/05/2007 1 X 20 17/06/2007 1 X 20 27/06/2007 1 x 40 "Narnimar" wrote: The below is my List of date effecting and the size code. 23/05/2007 1 X 20 28/05/2007 3 X 40 15/06/2007 3 X 40 15/06/2007 2 X 20 17/06/2007 1 X 20 18/06/2007 3 X 40 19/06/2007 4 X 20 20/06/2007 2 X 20 24/06/2007 6 X 20 27/06/2007 1 x 40 for which I am trying to get a formula to calculate the total rental charges to pay as on today by adding the prices depending on no. of days from effecting date. Both the Tables below are to be applied to find out the total rent charges. If the above Dates are in column A & sizes are in B can I get the total amount in C? RENTAL CHARGES- DAYS 1 x 20 1 x 40 8 to 17 Days 19.00 38.00 18 to 32 Days 24.00 43.00 33 Days & above 30.00 48.00 SPACE RENT 8. to 14 Days 35.00 70.00 15 Days & above 70.00 140.00 Anybody can please help me? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate total rent charges
Toppers,
I could not send it to this you email ID. Can you geve me any other alternative email Id? RENTAL CHARGES- SPACE RENT days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @19 18 - 32nd=15days @24 33+?days @24 total 1 - 7th=8days @zero 8 - 14th=7days @35 15+ ?days @70 total Answer 1 23/05/2007 1 x 20 46 8days =0 10days =190 15days=360 13 days=420 46days =970 8days =0 7days =245 31 days=2170 46days =2415 46days =3385 2 17/06/2007 1 x 20 21 8days =0 10days =190 3days=72 nil 21days =262 8days =0 7days =245 6days =420 21days =665 21days =927 days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @38 18 - 32nd=15days @43 33+?days @48 total 1 - 7th=8days @zero 8 - 14th=7days @70 15+ ?days @140 GRAND TOTAL 3 27/06/2007 1 x 40 11 8days =0 3days=114 nil nil 11days =114 8days =0 4days =280 nil 11days =280 11days =394 Please copy this to excel & check it As on 07/07/07, 46 days t0 be taken into account. "Toppers" wrote: Please e-mail me at: toppers <at NOSPAMjohntopley.fsnet.co.uk and I will send a sample solution. Can you also provide answers to the following, assuming TODAY = 07/07/07, so I can check my results: 23/05/2007 1 X 20 17/06/2007 1 X 20 27/06/2007 1 x 40 "Narnimar" wrote: The below is my List of date effecting and the size code. 23/05/2007 1 X 20 28/05/2007 3 X 40 15/06/2007 3 X 40 15/06/2007 2 X 20 17/06/2007 1 X 20 18/06/2007 3 X 40 19/06/2007 4 X 20 20/06/2007 2 X 20 24/06/2007 6 X 20 27/06/2007 1 x 40 for which I am trying to get a formula to calculate the total rental charges to pay as on today by adding the prices depending on no. of days from effecting date. Both the Tables below are to be applied to find out the total rent charges. If the above Dates are in column A & sizes are in B can I get the total amount in C? RENTAL CHARGES- DAYS 1 x 20 1 x 40 8 to 17 Days 19.00 38.00 18 to 32 Days 24.00 43.00 33 Days & above 30.00 48.00 SPACE RENT 8. to 14 Days 35.00 70.00 15 Days & above 70.00 140.00 Anybody can please help me? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate total rent charges
sorry ... forget to say remove NOSPAM
toppers <at NOSPAMjohntopley.fsnet.co.uk "narnimar" wrote: Toppers, I could not send it to this you email ID. Can you geve me any other alternative email Id? RENTAL CHARGES- SPACE RENT days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @19 18 - 32nd=15days @24 33+?days @24 total 1 - 7th=8days @zero 8 - 14th=7days @35 15+ ?days @70 total Answer 1 23/05/2007 1 x 20 46 8days =0 10days =190 15days=360 13 days=420 46days =970 8days =0 7days =245 31 days=2170 46days =2415 46days =3385 2 17/06/2007 1 x 20 21 8days =0 10days =190 3days=72 nil 21days =262 8days =0 7days =245 6days =420 21days =665 21days =927 days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @38 18 - 32nd=15days @43 33+?days @48 total 1 - 7th=8days @zero 8 - 14th=7days @70 15+ ?days @140 GRAND TOTAL 3 27/06/2007 1 x 40 11 8days =0 3days=114 nil nil 11days =114 8days =0 4days =280 nil 11days =280 11days =394 Please copy this to excel & check it As on 07/07/07, 46 days t0 be taken into account. "Toppers" wrote: Please e-mail me at: toppers <at NOSPAMjohntopley.fsnet.co.uk and I will send a sample solution. Can you also provide answers to the following, assuming TODAY = 07/07/07, so I can check my results: 23/05/2007 1 X 20 17/06/2007 1 X 20 27/06/2007 1 x 40 "Narnimar" wrote: The below is my List of date effecting and the size code. 23/05/2007 1 X 20 28/05/2007 3 X 40 15/06/2007 3 X 40 15/06/2007 2 X 20 17/06/2007 1 X 20 18/06/2007 3 X 40 19/06/2007 4 X 20 20/06/2007 2 X 20 24/06/2007 6 X 20 27/06/2007 1 x 40 for which I am trying to get a formula to calculate the total rental charges to pay as on today by adding the prices depending on no. of days from effecting date. Both the Tables below are to be applied to find out the total rent charges. If the above Dates are in column A & sizes are in B can I get the total amount in C? RENTAL CHARGES- DAYS 1 x 20 1 x 40 8 to 17 Days 19.00 38.00 18 to 32 Days 24.00 43.00 33 Days & above 30.00 48.00 SPACE RENT 8. to 14 Days 35.00 70.00 15 Days & above 70.00 140.00 Anybody can please help me? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate total rent charges
I believe some of your calculations are incorrect: check number of days in
the various ranges. "Toppers" wrote: sorry ... forget to say remove NOSPAM toppers <at NOSPAMjohntopley.fsnet.co.uk "narnimar" wrote: Toppers, I could not send it to this you email ID. Can you geve me any other alternative email Id? RENTAL CHARGES- SPACE RENT days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @19 18 - 32nd=15days @24 33+?days @24 total 1 - 7th=8days @zero 8 - 14th=7days @35 15+ ?days @70 total Answer 1 23/05/2007 1 x 20 46 8days =0 10days =190 15days=360 13 days=420 46days =970 8days =0 7days =245 31 days=2170 46days =2415 46days =3385 2 17/06/2007 1 x 20 21 8days =0 10days =190 3days=72 nil 21days =262 8days =0 7days =245 6days =420 21days =665 21days =927 days to be accounted 1 - 7th=8days @zero 8 - 17th=10days @38 18 - 32nd=15days @43 33+?days @48 total 1 - 7th=8days @zero 8 - 14th=7days @70 15+ ?days @140 GRAND TOTAL 3 27/06/2007 1 x 40 11 8days =0 3days=114 nil nil 11days =114 8days =0 4days =280 nil 11days =280 11days =394 Please copy this to excel & check it As on 07/07/07, 46 days t0 be taken into account. "Toppers" wrote: Please e-mail me at: toppers <at NOSPAMjohntopley.fsnet.co.uk and I will send a sample solution. Can you also provide answers to the following, assuming TODAY = 07/07/07, so I can check my results: 23/05/2007 1 X 20 17/06/2007 1 X 20 27/06/2007 1 x 40 "Narnimar" wrote: The below is my List of date effecting and the size code. 23/05/2007 1 X 20 28/05/2007 3 X 40 15/06/2007 3 X 40 15/06/2007 2 X 20 17/06/2007 1 X 20 18/06/2007 3 X 40 19/06/2007 4 X 20 20/06/2007 2 X 20 24/06/2007 6 X 20 27/06/2007 1 x 40 for which I am trying to get a formula to calculate the total rental charges to pay as on today by adding the prices depending on no. of days from effecting date. Both the Tables below are to be applied to find out the total rent charges. If the above Dates are in column A & sizes are in B can I get the total amount in C? RENTAL CHARGES- DAYS 1 x 20 1 x 40 8 to 17 Days 19.00 38.00 18 to 32 Days 24.00 43.00 33 Days & above 30.00 48.00 SPACE RENT 8. to 14 Days 35.00 70.00 15 Days & above 70.00 140.00 Anybody can please help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate rent over time with interest increase included | New Users to Excel | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
How do I calculate charges based on elasped time(H:MM) & rate($)? | Excel Discussion (Misc queries) | |||
How do I automatically total and flag charges when they reach a s. | Excel Discussion (Misc queries) |