Pesky percentage problem

[Darran]

Hi everyone,

I'm compiling some information and want to to show target V actual as a percentage.

Target Actual Performance
137 88 64% of the way to achieving the target
2.7 2.6 102% This issue I have here is the actual needs to be lower than target for it to be positive and I want to show the result as +2% not 102%

The formula I"m using it =IF(MIN(F25,G25)<=0,IF(G25-F25)>0,"P","N"),(G25/F25)-1)

Is there an easy way to do this?

Any help will be greatly appreciated as I'm getting grayer by the minute here.

Thanks
Darran

 

[NARAYANK991]

Hi ,

Your problem is not clear.

88/137 gives 64 % , but why does it become 102 % for the next comparison ? Should it not be 2.6/27 which would give 96 % ?

Narayan

 

[xlstime]

Littler confused, How did you calculate 102%? it should be -4%.

and our formula there are some brackets error, see rectified one

=IF(MIN(F25,G25)<=0,IF((G25-F25)>0,"P","N"),(G25/F25)-1)

can you upload sample sheet with required output.

Hi everyone,

I'm compiling some information and want to to show target V actual as a percentage.

Target Actual Performance
137 88 64% of the way to achieving the target
2.7 2.6 102% This issue I have here is the actual needs to be lower than target for it to be positive and I want to show the result as +2% not 102%

The formula I"m using it =IF(MIN(F25,G25)<=0,IF(G25-F25)>0,"P","N"),(G25/F25)-1)

Is there an easy way to do this?

Any help will be greatly appreciated as I'm getting grayer by the minute here.

Thanks
Darran

 

[Darran]

Hi ,

Your problem is not clear.

88/137 gives 64 % , but why does it become 102 % for the next comparison ? Should it not be 2.6/27 which would give 96 % ?

Narayan

Hi Narayan,

Yes this is a bit confusing, In the first example we have a target of 137 and our actual is 88, so we can either be 64% of the way to achieving our target or -36% below target depending on how you want to display it.

Now the second data set has a target of 2.7 and an actual of 2.6. in this instance our target is an interval in days, eg: to achieve target we can only have an interval of 2.7 days between a donation. Currently we are obtaining a donation with an interval of 2.6. Therefore we are actually doing better than target by 0.1.

I can get the second example to display as 102% which is correct, however I'm asking is there a way to display the result as +2% of target.

Sorry if I made my first post a little confusing.

Thanks
Darran

 

[NARAYANK991]

Hi ,

Sorry , but I am still not clear about your requirement.

1. Excel strictly deals with numbers and functions / formulae ; how to interpret those numbers is up to the user. The formulae have to be developed based on a user's requirements so as to return the desired outputs.

2. Bringing in terminology into the matter is not required , except if an application is being developed , and if its scope is quite large.

Here , if we wish to make things simple , let us first stop using terminology.

You have a column of numbers , one after another.

Can you explain what needs to be done with any 2 successive numbers ?

Will the same rule be applied to any two successive numbers ?

Narayan