Forum Discussion

Cjlodd's avatar
Cjlodd
Copper Contributor
Mar 26, 2021

Cell to Display value "C" or "NC" base on % of data range

Hi,

 

Fairly new to using excel formulas and could use a hand i am trying to Display a value ("C" or "NC") in cell C5 based on the percentage of "RT" or "NC" from cells D5-K5. Yellow(blank) cells are irrelevant to the equation

Im looking have the "Overall score" column update as data is entered and this would be a very large time saver.Data range

Charting
excel
Excel on Mac
Formulas and Functions

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 26, 2021

    Cjlodd 

    Can you tell us how we decide whether to return C or NC? "based on the percentage of" is rather vague...

    • Cjlodd's avatar
      Cjlodd
      Copper Contributor
      Mar 26, 2021

      HansVogelaar 

       

      Hi thanks for the response , id like to display "NonCompliant" or "Compliant" based on the percent of "RT" and "NC" cells per row.

      I am currently using the following formula temporarily. 

      =IF(COUNTIF(D19:BZ19,"RT")<COUNTIF(D19:BZ19,"NC"),"Non-Compliant","Compliant")

       

      After giving some extra thought to the process, i think i need work out what has the highest Percentage of the entire row and display that in the Box.