Look at two different cells, refer to a 3rd, return value in 4th

[Closed]
Report
-
Hello,



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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!