I made a box with values(e.g. N = No Work, 1 = New Ceiling Tile, 2 = New etc.). How do I write a function so that it will check all the values. The only thing I remember from school is else or elseif statements. Can you do those in Excel or is there just some way I'm naive to?