Using If Function

		Microsoft Office Forums > Microsoft Excel > Excel
Using If Function

01-14-2019, 07:56 AM

Marcia

Windows 7 32bit Using If Function

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

Add quotation marks before and after the X, like
=if(A2="X","Sales",0)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM
how to use now() function	gsrikanth	Excel	1	01-07-2012 01:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 AM.