I am working on a worksheet and want to return a value from a column entitled "Possible Points" depending on which column is checked, "Yes", "No", or "N/A". In this case, the students get points for either "Yes" or "N/A". Column H is my Possible Points column, and the two columns I put "X" in (for points) are column C and column E. What would that formula look like?
In recap, If there is an "x" in either column C or Column E for that activity, I want to refer to the Possible points column and then return that value to the Actual Points column G.
Look at two different cells, refer to a 3rd, return value in 4th