# 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

+ Add a Comment