Does anyone know how to write an Excel formula that takes the highest value from two cells and simultaneously neglect missing value code 999?

I have collected data on educational level (1-4) in the household, and need a function that extract the highest value in the family. In case of missing values (999), the formula should only report...

10 October 2015 3,299 4 View