| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA NEEDED
IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES"
iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Try this:
=IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
You can purchase a book on Excel such as John Walkenbach's Excel 2003 Bible
or Excel 2007 Bible. And stop yelling. (That means using capitals). Tyro "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Sorry, I forget that Caps Lock is on.
No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Then.....
Try this: =IF(COUNTIF(Q1,"*ok*"),"YES","something else") or.. =IF(COUNTIF(Q1,"*ok*"),"YES","") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Try it this way:
=IF(ISNUMBER(SEARCH("ok",Q1)),"YES","something else") Allows you to look for the letters "OK" (case insensitive) within the text in Q1. Hope this helps. Pete On Mar 17, 4:36*pm, Angie wrote: Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 *but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll *probably get an answer from *this forum faster than you can find the answer in *Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE.- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Pete,
Thanks for the tip on "Search." I didn't know that function existed. -- Ken Hudson "Pete_UK" wrote: Try it this way: =IF(ISNUMBER(SEARCH("ok",Q1)),"YES","something else") Allows you to look for the letters "OK" (case insensitive) within the text in Q1. Hope this helps. Pete On Mar 17, 4:36 pm, Angie wrote: Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE.- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
You're welcome, Ken - thanks for feeding back.
If you want it to be case sensitive you can use the FIND function. The problem with the above is that it would count a word like "book" if that was in the string, but using something like "*ok*" couldn't guarantee to find all OK's if the text began with OK. Pete On Mar 17, 10:32*pm, Ken Hudson wrote: Pete, Thanks for the tip on "Search." I didn't know that function existed. -- Ken Hudson "Pete_UK" wrote: Try it this way: =IF(ISNUMBER(SEARCH("ok",Q1)),"YES","something else") Allows you to look for the letters "OK" (case insensitive) within the text in Q1. Hope this helps. Pete On Mar 17, 4:36 pm, Angie wrote: Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 *but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll *probably get an answer from *this forum faster than you can find the answer in *Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
This work nicely, as well. Thank you!
"Pete_UK" wrote: Try it this way: =IF(ISNUMBER(SEARCH("ok",Q1)),"YES","something else") Allows you to look for the letters "OK" (case insensitive) within the text in Q1. Hope this helps. Pete On Mar 17, 4:36 pm, Angie wrote: Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE.- Hide quoted text - - Show quoted text - |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Thank you, This worked well.
"Ron Coderre" wrote: Then..... Try this: =IF(COUNTIF(Q1,"*ok*"),"YES","something else") or.. =IF(COUNTIF(Q1,"*ok*"),"YES","") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll probably get an answer from this forum faster than you can find the answer in Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Glad to hear it, Angie - thanks for feeding back.
Pete On Mar 18, 12:19*pm, Angie wrote: This work nicely, as well. Thank you! "Pete_UK" wrote: Try it this way: =IF(ISNUMBER(SEARCH("ok",Q1)),"YES","something else") Allows you to look for the letters "OK" (case insensitive) within the text in Q1. Hope this helps. Pete On Mar 17, 4:36 pm, Angie wrote: Sorry, I forget that Caps Lock is on. No this isn't working. The cell contains the work "OK" along with other phrases. THe cell value will not be "OK" This is where I meet my wall. I have tried formulas with =IF(Q1 *but I cannot use =IF(Q1= "Ron Coderre" wrote: Try this: =IF(Q1="ok","YES","something else") or...maybe... =IF(Q1="ok","YES","") Is that something you can work with? Whenever you have issues constructing a formula you'll *probably get an answer from *this forum faster than you can find the answer in *Excel Help. (Also...messages in all capital letters indicate that you're shouting.) -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Is it possible to do this -
Search for the word 'ok' or 'allright' in a character string. For instance, a sentence in cell A1, "I believe it would be ok" and a sentence "I think it would be allright", should bring up the output 'Yes' in cell B1. If a string doesnt have a set of certain words (in this case, 'ok' and 'allright'), then bring up the output 'No' "Tyro" wrote: You can purchase a book on Excel such as John Walkenbach's Excel 2003 Bible or Excel 2007 Bible. And stop yelling. (That means using capitals). Tyro "Angie" wrote in message ... IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE FINE. |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
It may not be the best formula but it works =IF(ISERROR(FIND("ok",A1,1)),IF(ISERROR(FIND("allr ight",A1,1)),"No","Yes"),"Yes") -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24672 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA NEEDED
Just to note - FIND is case-sensitive, whereas SEARCH is not. Also,
you don't really need to specify 1 as the third parameter. Hope this helps. Pete On Nov 3, 10:10*pm, mudraker wrote: It may not be the best formula but it works =IF(ISERROR(FIND("ok",A1,1)),IF(ISERROR(FIND("allr ight",A1,1)),"No","Yes"),*"Yes") -- mudraker ------------------------------------------------------------------------ mudraker's Profile:http://www.thecodecage.com/forumz/member.php?userid=18 View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=24672 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed. | Excel Discussion (Misc queries) | |||
| IF/AND/OR FORMULA HELP NEEDED | Excel Discussion (Misc queries) | |||
| Appropriate formula needed! | Excel Discussion (Misc queries) | |||
| Formula help needed ! | Excel Discussion (Misc queries) | |||
| Formula Set Up Needed | Charts and Charting in Excel | |||
Linear Mode
