Hi,
im trying to calculate how close to target the sales team are
in col C i have their plan, in col D i have what they have made so far and have this formula in col F =(C4-D4)/C4
it shows me how far in % they are to the plan but if someone has over acheived it gives me a negative %
but that wouldnt be right has they have gone beyond the plan.
col C 764,403 col d 679,334 col f 11% so they are 11% away from reaching their target
<tbody>
</tbody><colgroup><col></colgroup>
any ideas plse?
thanx in advance for your help
im trying to calculate how close to target the sales team are
in col C i have their plan, in col D i have what they have made so far and have this formula in col F =(C4-D4)/C4
it shows me how far in % they are to the plan but if someone has over acheived it gives me a negative %
but that wouldnt be right has they have gone beyond the plan.
col C 764,403 col d 679,334 col f 11% so they are 11% away from reaching their target
<tbody>
</tbody><colgroup><col></colgroup>
any ideas plse?
thanx in advance for your help