Check out How To Use Percent In Mac Numbers at YouTube for closed captioning and more options.
How To Use Percent In Mac Numbers
Comments: 2 Responses to “How To Use Percent In Mac Numbers”
Comments Closed.
Check out How To Use Percent In Mac Numbers at YouTube for closed captioning and more options.
I have a single column of numbers. Some numbers are positive numbers and some are negative numbers. I need a formula to determine what percentage of numbers from that column are positive numbers.
George: Use COUNTIF to determine how many positive numbers there are and COUNTA to determine how many numbers total. So if the column is B, then COUNTIF(B,">0")÷COUNTA(B)