excelidiothelpme
New Member
- Joined
- Feb 22, 2022
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
Not sure which formula to use:
Example - 04.03.2022.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
1 | Option | A | A | B | C | |||||||
2 | Prev YTD GP | Budget YTD GP | Increase in R | Increase % | Budget YTD GP | Budget YTD GP | Budget YTD GP | |||||
3 | Employee 1 | R 10.00 | R -10.00 | -100.00% | R 12.00 | R 14.00 | R 15.00 | |||||
4 | Employee 2 | R 15.00 | R -15.00 | -100.00% | R 15.00 | R 16.00 | R 17.00 | |||||
5 | Employee 3 | R 20.00 | R -20.00 | -100.00% | R 20.00 | R 20.00 | R 20.00 | |||||
6 | Employee 4 | R 5.00 | R -5.00 | -100.00% | R 10.00 | R 12.00 | R 12.00 | |||||
7 | Employee 5 | R 6.00 | R -6.00 | -100.00% | R 8.00 | R 10.00 | R 12.00 | |||||
8 | Employee 6 | R 10.00 | R -10.00 | -100.00% | R 10.00 | R 10.00 | R 10.00 | |||||
9 | Employee 7 | R 12.00 | R -12.00 | -100.00% | R 12.00 | R 12.00 | R 12.00 | |||||
10 | ||||||||||||
11 | Want Cells D3:D9 to update according to the option in Cell D1. | |||||||||||
12 | Preferably, I want D1 to be a dropdown menu where I select either A,B or C and cells D3:D9 update accordingly. | |||||||||||
13 | ||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3:E9 | E3 | =D3-C3 |
F3:F9 | F3 | =D3/C3-1 |