I start with a specific number. Lets say 1557.
I then have 5 steps which will be 5 different columns in excel which add up to 1557.
The first step starts at 27 the second step 63, the 3rd 157.5, 4th 382.5 and the 5th 927. So if we add all the steps up it will equal 1557.
Each Step will equal 70% of that number. EG 27 = 70% of 27= 18.9 Step 2 70% of 63=44.1 ect.
When the first step is deducted from the specific number, the second steps 70% must equal greater then the specific number, by the first steps 70%.
EG: Specific number is 1557, first step is 27. 1557 - 27 = 1530. So now the second steps 70 % must equal greater then 1557 by the first steps 70% (70 of 27=18.9) which is 1557 + 18.9 = 1575.9.
If the first step is deducted from the specific number and the second step is deducted from the specific number then the 3rd step must equal greater then the specific number by the original first steps 70% amount. EG: specific number = 1557 - first step (27) - second step (63) = 1467 so now the 3rd steps 70% must equal the same as the first steps 70%. So now the sum should equal 1575.9. This must happen for all the steps 1-5
I want to be able to simply input the specific number and all the steps show up straight away.
I would like it to show the Step number, how much eg 27 for first step and what that step equal from 70% (18.9) all the way to step 5.
It could look something like this on Excel:
Specific number: 1557
Step1 Step 2 Step 3........ ..................Step5
27=18.8 63= 44.1
So to clarify all the steps have to add up to 1557 or what ever specific number I choose to input.
Each Step has to have a 70% value
If step 1 is deducted then step 2's 70% has to add to step 1's 70% + 1557 (specific number)
If step 1,2,3,4 is deducted then step 5 has to add to step 1's 70% + 1557 (specific number)
Simple
Dear eureka888,
VBA expert here.. Please award project.. I've started working on it and can deliver this within 3-4 hrs.
As I'm building the logic, can you please a sheet where you've put some numbers manually..? I want to see how you place these in excel.
Best Regards,
Microk
[login to view URL]
$25 AUD σε 3 ημέρες
4,8 (24 αξιολογήσεις)
4,4
4,4
18 freelancers δίνουν μια μέση προσφορά $25 AUD για αυτή τη δουλειά
Good day,
I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Hi, would it be possible to send me the table showing all the desired results for the 5 steps for the specfic number 1557. That would help better understand the concept. Thanks
I am available at any time , flexible in working anywhere and anytime as i own a laptop excellent internet connection, fast internet speed. A very discipline person,will complete work in duration stated. Good in open office Calc and ms office Excel. Able to work on own given with clear instructions on what to do exactly.
I have enough skills to do this job. So, you have no doubts to offer this job to me. Any how you search my abilities and decide whether award or not.
Good luck
Hi,
I have completely understood your requirement about the data entry and i am a data entry professsional who can be fitted to any sort of a article writing and documenting.
I pocess very good knowledge about the Microsoft Desktop Office Applications and other Documenting softwares such as ImageReady PageMaker and etc.
PM to initiate your task and i can gurantee the time frame under any circumstances.
I AM READY TO START YOUR JOB
Regards,
Sumedha Nanayakkara
Hello, I am the best candidate for the short project because I work with Excel daily, especially with formulas like this. I will complete the assignment within 12 hours. Hope to work with you.
Thanks
I am conversant with Excel and I am sure to deliver to your expectations. However, I seek afew clarifications. If the starting number is 1557 how did you get the the first to the fifth step numbers,that is 27,63,157.5,382.5 and 927. Also not understood is your sentence ' So now the second steps 70% must equal greater than1557 by the first steps70%(70%of 27=18.9) which is 1557+18.9=1575.9.' 70%of 2nd step=44.1 cannot be greater than 1557. Please explain further.
It would be better if you give me the expected results in the form of a table
Knowledge honesty and commitment, I know that I can work with comfort and ease. I have an MBA degree and so it is so simple for me to accomplish this task in time.