Forum Discussion
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 a...
Can you tell us how we decide whether to return C or NC? "based on the percentage of" is rather vague...
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.
I'd say your current formula does what you want.