N
Nick Horn
I need to use LOOKUP or a variation (e.g. VLOOKUP) to convert numbers
(representing Grades) to numbers (representing points). Some of the pupils
do not have results and so LOOkUP returns #N/A.
How can I avoid it doing this? The resultant cell values will be used to
calculate means, standard deviation and COUNTIF calculations.
Many thanks for any help.
(representing Grades) to numbers (representing points). Some of the pupils
do not have results and so LOOkUP returns #N/A.
How can I avoid it doing this? The resultant cell values will be used to
calculate means, standard deviation and COUNTIF calculations.
Many thanks for any help.