Populate Number Based on Criteria

[kumara_faith]

Hi,

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.

 

[kumara_faith]

Hi,

Appreciate any help.

 

[awoohaw]

your mini worksheet has a formula that references column B but, you don't show column B. Is this going to be repeated down rows (if repeated down rows it may be more difficult to solve? Or is this a single arithmetic question?

 

[kumara_faith]

Hi,

My apologies. Cell F4 should be the total of cell C4 and D4 which should be 59.