Macro Generate Numbers with Condition

[joram7]

I need help with a macro where numbers are auto generated in the highlighted yellow cell based on the condition below. The numbers should be trigger based on the percentage allocated.

Condition
For Scenario A,B,C all total must be equal or higher than Cost A
Round up to 0 decimal
All scenario are trigger by the percentage allocation ( % is determine mannualy)

Scenario B
Domestic must be 30
Regional must not be lower than 30 and higher than 60
International must be 60 or higher

Scenario C
Domestic must be 30
International must not be lower than 30

Sample - Mr-excel question.xls
	C	D	E	F	G	H	I
8
9
10	NumberofCount		1,000		1,000		1,000
11
12
13	Scenario	A		B		C
14
15		Range	Value	Range	Value	Range	Value
16		International	59	Domestic	30	Domestic	30
17				Regional	55	International	80
18				International	65
19
20
21
22
23	TierAllocation	Range	Percentage	Range	Percentage	Range	Percentage
24	Tier1	International	100.0%	Domestic	20.0%	Domestic	10.0%
25	Tier2			Regional	50.0%	International	90.0%
26	Tier3			International	30.0%
27	Tier4
28	Tier5
29
30
31
32	Total		59,000		53,000		75,000
33	CostA		58,211		58,211		58,211
34
35
Fee_Scenario

 

[joram7]

any help?

 

[Sal Paradise]

Your information doesn't make much sense.

Solve for International, Domestic and Regional and you get 1000, 333.333... and -400 respectively. How you're determining anything is totally unknown to us. Try explaining more clearly with a step-by-step example of how you'd solve the problem now, what your logic is, and where you're getting your data from.

 

[tusharm]

Take a look at Excel's Solver (Tools | Solver...) You can use it to adjust the % numbers so that the final numbers match your requirement.

I need help with a macro where numbers are auto generated in the highlighted yellow cell based on the condition below. The numbers should be trigger based on the percentage allocated.

Condition
For Scenario A,B,C all total must be equal or higher than Cost A
Round up to 0 decimal
All scenario are trigger by the percentage allocation ( % is determine mannualy)

Scenario B
Domestic must be 30
Regional must not be lower than 30 and higher than 60
International must be 60 or higher

Scenario C
Domestic must be 30
International must not be lower than 30

{snip}