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

New Contributor

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 rangeData range

3 Replies

@Cjlodd 

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

@Hans Vogelaar 

 

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. 

 

 

 

@Cjlodd 

I'd say your current formula does what you want.