98%

  1. Z

    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. R

    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. R

    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. V

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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top