Mar 26 2021 12:42 AM
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.
Mar 26 2021 04:03 AM
Can you tell us how we decide whether to return C or NC? "based on the percentage of" is rather vague...
Mar 26 2021 06:07 PM
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.
Mar 27 2021 01:55 AM
I'd say your current formula does what you want.