Using the "IF" function in M/soft Excel

Mark-335400 19:16 07 May 03
Locked

I need to get excel to look at a cell for either the letter R, E or SBF to give me a value of "Y" if true or "0" if false. I am trying to do it useing the function wizard and entering the arguement in the logical test field,,, please help... thanks in advance

Newuser4132 19:22 07 May 03

Is this what you need?
=IF(A4="R","Y",IF(A4="e","Y",IF(A4="sbf","Y",0)))

VoG™ 19:27 07 May 03

=IF(OR(A1="R",A1="E",A1="SBF"),"Y",0)

Mark-335400 20:05 07 May 03

Newuser4132 (Ken Phillips), VoG™.... Thanks,, spot on (whichever way).. We had spent a couple of hours at work this afternoon trying to work that one out and got knowhere, as Chris Tarrant would say "it's only easy if you know the answer". (better book myself onto that Excel course at the local college) MANY, MANY THANKS

This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…