I have 2 columns for values of Pass, Fail, NA.
Let's say I have 8 condition to test (actually way more).
The results a 4 passed, 2 failed and 2 NA's.
I have 3 cells that I want to put the results as a percentage (%Passed,
%Failed, %na). What would be the best way to do this.
Thanks ahead to all that helps.
C1 D1 E1 F1
test results: %Passed %Failed %NA
50 25 25
A3 B3 C3
pass fail
test 1 f
test 2 p
test 3 p
test 4 p
test 5 f
test 6 na
test 7 p
test 8 na