Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Excel IF function

Answer this Question Ask about Spreadsheets
 
Thread Tools Display Modes
Question
 
 
#1  
Old Dec 18, 2007, 03:39 AM
Sheriff_Dan
New Member
Sheriff_Dan is offline 		 
Join Date: Dec 2007
Posts: 1
Sheriff_Dan See this member's comment history on his/her Profile page.
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

Reply With Quote
 
     

Answers
 
 
Old Dec 19, 2007, 06:10 AM   #2  
Junior Member
mdosh01 is offline
 
Join Date: Dec 2007
Posts: 39
mdosh01 See this member's comment history on his/her Profile page.
Are you enclosing the test in double quotation marks? For example:

=if(d6="hello","hi","goodbye") or =if(d6="hello",0,1)
  Reply With Quote
 
     
 
 
Old Dec 19, 2007, 06:48 AM   #3  
Computer Expert
ScottGem is online now
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 25,414
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
It would have helped if you show us what formula you are entering, but you do need to surround text strings with quotes.
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
Excel function claired Spreadsheets 1 Dec 2, 2007 03:26 AM
Excel formula IF function AJC_50 Spreadsheets 2 Oct 4, 2007 02:34 PM
Excel Count Function eddiegeorge Spreadsheets 4 Mar 22, 2007 10:33 AM
How to remove a character using Excel function dogdog3 Spreadsheets 3 Aug 5, 2006 06:01 AM
Excel count function fyogi1 Spreadsheets 7 Apr 26, 2006 07:10 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 12:05 PM.