I'm looking for the command that would allow me to assign a point value to a response in another cell. For instance, if you answer yes in one cell, the cell next to it would give you 10 points. If you said no, the next cell would show a zero....make sense?

Can you advise the formula?