# 98%

1. ### return certain value

hello, i would like to know if i want excel to return certain values based on results received. example: if employee reaches 95% then he gets 1 if 98% then 2 100% then 3 120% then 4 200% then 5 what is the equation to use for such examples
2. ### Getting numbers of scores to get average

Hi guys, Need some experts to shed light on me. Trying to come up with a formula to get how many 100% scores do I need to get to 98% if my table looks like this: <colgroup><col><col><col><col></colgroup><tbody> Current Attempts Running Score Goal How many 100% audits needed? 87 96% 98%...
3. ### Percentage Formula Driving Me ....

Hi All, I have total units of 787 (J3) & errors of 5 (N3), cell formatted to % . Formula I Cell O3 : = N3/J3 , answer in my opinion should be around 98% , why is my formula displaying 1 % ??? Sorry if this sounds daft … but its driving me mad ! Many thanks, Russ
4. ### Autofill data from above cell while Grouping

Hello I need a macro to re-create the below auto generated report in the below format Original source: <colgroup><col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;" span="7"> <tbody> Process Code Date Population Size Sample Size Pass Fail...

### 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