theraindew
New Member
- Joined
- Dec 7, 2018
- Messages
- 11
- Office Version
- 365
- 2016
- Platform
- Windows
Below is a sample table i'm working on. We have an opening number for each member in B and a target closing number in C. Column D is the actual closing number. e.g. Mem5 target is 17,000 and closing is 17,000, Column E should show 100%.
Mem4 target is 18,400, but opening and closing are same at 92,000, column E should show 0%.
I just cannot wrap my head around how to achieve this. Appreciate any help on this.
Thank you
Excel 2013/2016
<tbody>
</tbody>
Mem4 target is 18,400, but opening and closing are same at 92,000, column E should show 0%.
I just cannot wrap my head around how to achieve this. Appreciate any help on this.
Thank you
Excel 2013/2016
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Name | Opening Number | Target | Closing Number | Target achieved % |
2 | Mem1 | 90,000 | 18,000 | 75,000 | |
3 | Mem2 | 75,000 | 15,000 | 72,000 | |
4 | Mem3 | 80,000 | 16,000 | 40,000 | |
5 | Mem4 | 92,000 | 18,400 | 92,000 | |
6 | Mem5 | 85,000 | 17,000 | 17,000 | |
7 | Mem6 | 97,000 | 19,400 | 25,000 | |
8 | Mem7 | 76,000 | 15,200 | 76,000 | |
9 | Mem8 | 91,000 | 18,200 | 36,000 | |
10 | Mem9 | 87,000 | 17,400 | 17,400 | |
11 | Mem10 | 89,000 | 17,800 | 50,000 |
<tbody>
</tbody>
Sheet1