hi,

i am trying to write a goalseek macro with a minimum GoalSeek Goal to
generate premium rates for different ages.

i have a group of people from
age = 17 to 60

and i set my goal to be
profit margin = 10% for age 17 to 30
= 20% for age 31 to 60

so i need to change the premium rates


i can get the standard macro but i would like to vary the profit margin
by age
Range("AK129").GoalSeek Goal:=0.10, ChangingCell:=Range("D12").

Appreciate any help on this. Thanks!


--
ernestgoh
------------------------------------------------------------------------
ernestgoh's Profile: http://www.excelforum.com/member.php...o&userid=24870
View this thread: http://www.excelforum.com/showthread...hreadid=554454

ernestgoh Wrote:
hi,

i am trying to write a goalseek macro with a minimum GoalSeek Goal to
generate premium rates for different ages.

i have a group of people from
age = 17 to 60

and i set my goal to be
profit margin = 10% for age 17 to 30
= 20% for age 31 to 60

so i need to change the premium rates


i can get the standard macro but i would like to vary the profit margin
by age
Range("AK129").GoalSeek Goal:=0.10, ChangingCell:=Range("D12").

Appreciate any help on this. Thanks!

anyone has any idea what i mean? thanks!


--
ernestgoh
------------------------------------------------------------------------
ernestgoh's Profile: http://www.excelforum.com/member.php...o&userid=24870
View this thread: http://www.excelforum.com/showthread...hreadid=554454