Using "if" function

		Microsoft Office Forums > Microsoft Excel > Excel
Using "if" function

FAQ

Thread Tools

Display Modes

06-17-2012, 04:32 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Using "if" function

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

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"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to "deactivate" the Excel's SAVE function	KIM SOLIS	Excel	1	11-05-2011 01:57 AM
Error: "The function you are attempting to run contains macros"	Fadi	Word	1	11-01-2011 05:25 AM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 PM.