Ask Your Question

Revision history [back]

I want to check for a string and then add to another variable

What I am trying to do is be able to input into a space either a "yes", "no", or "late" and then add to a tally in another space dependent on what was entered.

I have been looking at either nested if statements or at the vlookup function but I wanted to see if anyone would know a more efficient way of doing it?