If Then Formula

HEY GUYS THANK YOU IN ADVANCED FOR THE HELP…

I GUESS MY QUESTION IS HOW DO I MAKE A IF THEN STATEMENT THAT RETURES A WORD..

EX.. IN A1 I WOULD INPUT THE DAY (SAT) IN B1 ITS PRESET TO HAVE THE PERSONS NAME (DOE/JOHN) IN B2 IT ALSO PRESET WITH THE PERSONS CORROSPODAING DAYS OFF (SAT/SUN) HOW DO I RETURN THE WORD (OFF) IN C2 IF A1 IS TRUE.
THEN LOOP IT FOR THE REST OF THE PAGE

In C2 enter if formula

=IF(A1="Sat","Off","")

The "Sat" can be replaced by anything that you want to test for in A1

"Off" can be replaced by any word you like

"" will display nothing

Any words or sentance must be inclodes by " at the start & end.

To fill for other rows hust copy c1 and autofill down or copy and paste into required rows. I assume you know how to copy & paste