Ask Experts Questions for FREE Help !
Ask
    Sheriff_Dan's Avatar
    Sheriff_Dan Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 18, 2007, 04:39 AM
    Excel IF function
    I am trying to run the IF function in excel against text rather numerical values. However it does not seem to want to process the argument. Is there a way to get this to work?

    Cheers
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #2

    Dec 19, 2007, 07:10 AM
    Are you enclosing the test in double quotation marks? For example:

    =if(d6="hello","hi","goodbye") or =if(d6="hello",0,1)
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Dec 19, 2007, 07:48 AM
    It would have helped if you show us what formula you are entering, but you do need to surround text strings with quotes.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel count function [ 12 Answers ]

I am trying to count a large group of cells that are colored depending on the data. For example: I want to count the number of red cells which are faults. I tried the countif but not sure how to set the criteria. Thanks for any help.

Excel function [ 1 Answers ]

I am looking for a formula that allows me to have a specific text if the value in the cell selected is between 19xx and 19yy. I thought of using IF but can't figure it out... :( If the value is greater than 1967 and less than 1977 value = 30s

Excel formula IF function [ 2 Answers ]

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...

Excel Count Function [ 4 Answers ]

In November 2004 Leif 5233 wrote the following regarding counting cells highlighted in a certain colour: ------------------ Create this function: Function CountCol(SumRange As Range, intColor As Integer) As Integer Dim I As Integer Dim Cell As Range Set SumRange =...

How to remove a character using Excel function [ 3 Answers ]

Could anyone know if there is any Excel function that I can use to remove a certain character from a text string, e.g. 1). Remove space from "acurve is what" 2). Remove "-" from "acurve-is-what" 3). Remove "'" from "acurve'is" And so on. Thanks a lot!

View more questions Search