I am trying to calculate multiple cells to get percentage.
How would i give n/a cells a value or ignore n/a so that i still get a correct percentage. how can i keep n/a to show in the cell? Where would i plug formula in?
Some N/A value could be 1 and some could be 5
A B C D E F G H I J Score
5 5 5 5 n/a 5 5 5 5 na 100%
Thanks in advance
Bookmarks