if I put 1 under people and 1 in batch then it will make a new column heading di
ID: 1812067 • Letter: I
Question
if I put 1 under people and 1 in batch then it will make a new column heading division 1 and under the heading column place 2500 if I put 1 under people and 2 in batch then it will show under the division 1 heading column 2500*2 means 5000 if I put 2 under people and 1 in batch then same 2500 under division 1 column but then it will make a new column heading division 2 and under the heading column place 0 if I put 2 under people and 2 in batch then same 2500 under division 1 column and 2500 under column division 2now here comes a condition which is what if I increase batch not people more then two or three or four then the 2500 or 5000 or 7500 or 10000 will divide in all people equally but definitely at some stages any one person will get less then others then we should have one more column with people and batch that would be excess cash if we put any amount in that it will automatically be given to the less getting person or we want to divide the excess cash cell amount so starting person should be the one who has got the less share from intial batch division and same continues
need it on excel help please
mail the excel file and your name at fidaq20@gmail.com
i will rate 5 star here if I put 1 under people and 1 in batch then it will make a new column heading division 1 and under the heading column place 2500 if I put 1 under people and 2 in batch then it will show under the division 1 heading column 2500*2 means 5000 if I put 2 under people and 1 in batch then same 2500 under division 1 column but then it will make a new column heading division 2 and under the heading column place 0 if I put 2 under people and 2 in batch then same 2500 under division 1 column and 2500 under column division 2
now here comes a condition which is what if I increase batch not people more then two or three or four then the 2500 or 5000 or 7500 or 10000 will divide in all people equally but definitely at some stages any one person will get less then others then we should have one more column with people and batch that would be excess cash if we put any amount in that it will automatically be given to the less getting person or we want to divide the excess cash cell amount so starting person should be the one who has got the less share from intial batch division and same continues
need it on excel help please
mail the excel file and your name at fidaq20@gmail.com
i will rate 5 star here
Explanation / Answer
i mail the file
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.