kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 955
- Office Version
- 365
Hi,
I have the following table:
The total enquiry via walk in and virtual has a target reduction in cell H1 which is 10%. This means total enquiry needs to reduce to 59 from the current total 66. At the same time, Virtual Ratio needs to increase to 80%. Virtual ratio is calculated by taking the virtual volume divided by total volume which is 66. This ratio currently is 2% and needs to be increased to the target of 80%.
With the above criteria, is it possible to build a formula in cell C4 and D4? The above table shows the correct result for cell C4 and D4. Appreciate all the help.
I have the following table:
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
1 | 10% | |||||||
2 | Walk In | Virtual | Walk In Reduction | Total | Virtual Ratio | Reduction | ||
3 | 65 | 1 | 66 | 2% | 59 | |||
4 | 12 | 47 | -82% | 59 | 80% | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F3 | F3 | =SUM(C3:D3) |
G3:G4 | G3 | =D3/F3 |
H3 | H3 | =F3-(F3*H1) |
E4 | E4 | =(C4/C3)-1 |
F4 | F4 | =SUM(B4:D4) |
The total enquiry via walk in and virtual has a target reduction in cell H1 which is 10%. This means total enquiry needs to reduce to 59 from the current total 66. At the same time, Virtual Ratio needs to increase to 80%. Virtual ratio is calculated by taking the virtual volume divided by total volume which is 66. This ratio currently is 2% and needs to be increased to the target of 80%.
With the above criteria, is it possible to build a formula in cell C4 and D4? The above table shows the correct result for cell C4 and D4. Appreciate all the help.