Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash desktop dns driver drivers error ethernet excel freeze gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram registry repair router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: I Need Help with making a formula that involves words.

Reply  
Thread Tools
cnebb1981's Avatar
Junior Member with 4 posts.
 
Join Date: Nov 2009
19-Nov-2009, 01:07 PM #1
Question Solved: I Need Help with making a formula that involves words.
Hi, I'm curious if there is a way to make a formula in Excel that will produce a certain word in a cell, like "Yes" or "No" if a value in another cell is a certain number. For example if H7 = 0 then I7 = "No", but if its any other number then it will = "Yes". Thanks for any help.
olliea95's Avatar
Computer Specs
Member with 84 posts.
 
Join Date: Nov 2009
Location: London, UK
Experience: Advanced
19-Nov-2009, 02:08 PM #2
Yeah sure. The easiest way to do this is click on the cell you want the formula to be in (I7 I think you said) and click the 'fx' button next to the formula bar. You can then find the 'IF' option and click ok, this will then give you a window to enter in the information easily. The other way is to type the formula yourself, and it follows the syntax "=IF(comparison, ("value if true"), ("value if false")), so in your case it will be similar to "=IF(H7 = 0, ("Yes"), ("No")). (without the first and last quotes)

If typing the formula yourself doesn't work, it must be my fault, so try the 'fx' button if it doesn't. Also I'm sorry if this isn't very precise as I only have Excel 2003 and you may have another version.

-Ollie

Last edited by olliea95; 19-Nov-2009 at 02:10 PM.. Reason: Grammatical errors
cnebb1981's Avatar
Junior Member with 4 posts.
 
Join Date: Nov 2009
19-Nov-2009, 02:24 PM #3
Thumbs up It work! Thanks
Thanks it worked, I sure do appreciate it.
olliea95's Avatar
Computer Specs
Member with 84 posts.
 
Join Date: Nov 2009
Location: London, UK
Experience: Advanced
19-Nov-2009, 02:25 PM #4
You're welcome, got lucky as I was trying to recall from memory from about 6 months ago
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 09:33 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.