Search form

menu menu

Excel question

Question

Not expat related but google didn't help, maybe someone here can. I need a function in Excel that checks on the value of a particular cell: if the value 60, it returns a certain word, but if the value is text x or text y, it returns that same text. This would save me hours of work.

anon

=IF(A1=60,"Yes","No")
Where "Yes" is the value you want to return if A1 is 60 and "No" is the value you want returned if it isn't.

Feb 27, 2013 19:16