Ok, this may be a simple question, so i hope someone can help. How can I make an if statement that will, instead of producing a value for the statement's cell, perform an action on a different cell.
for example... if i put this formula into cell A1 with a value of a or p (for absent or...