The numbers in A, B,C, D are reference numbers, they should not be part of the calculation. What is the most efficient way to do this? The point is to create an overview of how many hours employees (1,2,3) have to spend spend on project B2:B6 for each week (E,F,G), and what happens if other employees take a certain percentage of the workload (C,D). You should see the result in your selected cell, but it is not a percentage value yet. A1(1+0. Type in the following formula and press the return key: ABS (B2-C2)/AVERAGE (B2,C2). You also use the formula in the flowing way where instead of using 100 you can use a 1 and for the increased percentage, you can decimal value. So for example in G7 the result for "1" should be 50% of 10 + 75% of 5, because "2" takes 50% of 10(G2) and "3" takes 25% of 5(G5). A1(100+10) The moment you hit enter, it will return the value by increasing it to 110. Now however I would like to subtract to that result the percentage in C1 and/or D1, and "give it" to one of the other blue numbers, again with the condition that there is a match between C2:C6 or D2:D6 and A7:A9. For Example, to subtract 10 from 8 can be found by using the following formula in Excel. We need to put the minuend as the one parameter and -Percentageminuend as the second parameter. I use the following formula to calculate the SUMPRODUCT of the values in a column with the condition that there is a match between B2:B6 and A1:A3 (shoutout to user:8162520). We can also make use of SUM FUNCTION to subtract the percentage.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |