# % of target

#### cynster76

##### New Member
I have data in %s. Target is fixed (ex. 7.5%). I want a formula to calculate % of target so if someone achieved 8.2% - result is 90.67% of target. While someone at 5.5% is 127% of target (overachieved).

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Scott Huish

##### MrExcel MVP
8.2% is higher than 7.5%, why is this result 90.67%?

#### cynster76

##### New Member
Because the lower the higher the number, the worse it is. Therefore below (less than 100%) target

#### cynster76

##### New Member
Sorry about that, the higher the number, the worse it is. So want to show this is being lower than 100%

#### shg

##### MrExcel MVP
I'm not at all sure what this computes, other than your example results:

=2-A1/7.5%

#### cynster76

##### New Member
Awesome, thanks! Cant believe is was so simple.

Replies
20
Views
587
Replies
8
Views
244
Replies
5
Views
104
Replies
3
Views
1K
Replies
3
Views
213

1,191,069
Messages
5,984,451
Members
439,888
Latest member
c3rberus

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back