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 |
