Hi,
Sure, your formula is really close but you need to add "" around the letter y
=IF(A2="y","pass","fail")
So, when you're using formulas, if you want to use a cell reference you just put that directly in the formula, eg. A1 or B3
If you want to use a word (ie. a String) then you have to surround it with "" , eg "Hello" or "y"
|