Excel ?, cell value based on text input in other cell 1

[ZiprHead]

I want a cell to display text based on the text input into another cell. Specifically, if someone enters a "Y" for yes, I want the next cell to display "Ontime". If the input to the first cell is "N" for no, I want the display to show "Late". If the first cell is blank, I want the second cell to be blank also.

This is probably a pretty simple thing to do but I've only had minimal excel training. Any help will be very much appreciated.

 

[dsi]

Just use an If statment. This monitors the value in A1:

=IF(A1="Y","On Time",IF(A1="N","Late",""))

 

[ZiprHead]

Thanks, that looks like just what i was looking for. I was making it more complicated than it needed to be.