View Single Post
 
Old 06-17-2012, 04:32 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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"
Reply With Quote