Formula for multi conditions

Count

% Final result
14 95% HIT
7 85% Exclude
35 120% MISS
37 85% MISS
42 100% HIT

Hi,

How to write formula in "Edit Calculation Column" for "Final resut" field:

if "Count" is >25 and "%" >90 and <110, then "Final result" is "HIT"

if "Count" is <25 and "%" >90 and <110, then "Final result" is "HIT"

if "Count" is >25 and "%" <90 and >110, then "Final result" is "MISS"

if "Count" is >25 and "%" <90 and >110, then "Final result" is "Exclude"

 

Thank you,

Bostjan

(2) Answers

Login