E
ernestgoh
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!
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!