98%

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

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

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

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