Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function + a formula
I am trying to figure out how I can use the IF function to identify a word,
such as "Home". If it is true, I need to do a formula on that line of information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot seem to add all this together and make it work. I am using Excel 2003. thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function + a formula
Try something like:
=IF(ISNUMBER(FIND("home",A1)),((C2-criteria)-M2)/60,"not found") BTW, "=+" is superfluous. "=" works just as well. Regards, Fred. "Cindyt" wrote in message ... I am trying to figure out how I can use the IF function to identify a word, such as "Home". If it is true, I need to do a formula on that line of information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot seem to add all this together and make it work. I am using Excel 2003. thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function + a formula
Are you trying to find Home in the text contained in a single cell (Fred
gave you code which should do that) or are you looking for the word Home in a column of data? Assuming the latter.. =IF(ISNUMBER(MATCH("Home",A1:A100,0)),(C2-Criteria-M2)/60,"") -- Rick (MVP - Excel) "Cindyt" wrote in message ... I am trying to figure out how I can use the IF function to identify a word, such as "Home". If it is true, I need to do a formula on that line of information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot seem to add all this together and make it work. I am using Excel 2003. thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function + a formula
Hi
The formula in the cell where you need the result could look like this: =if(A2="Home",+((C2-Criteria)-M2)/60,0) Regards, Per "Cindyt" skrev i meddelelsen ... I am trying to figure out how I can use the IF function to identify a word, such as "Home". If it is true, I need to do a formula on that line of information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot seem to add all this together and make it work. I am using Excel 2003. thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function + a formula
Is your system clock set correctly?
-- Rick (MVP - Excel) "Per Jessen" wrote in message ... Hi The formula in the cell where you need the result could look like this: =if(A2="Home",+((C2-Criteria)-M2)/60,0) Regards, Per "Cindyt" skrev i meddelelsen ... I am trying to figure out how I can use the IF function to identify a word, such as "Home". If it is true, I need to do a formula on that line of information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot seem to add all this together and make it work. I am using Excel 2003. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with OR function in IF function formula | Excel Worksheet Functions | |||
formula within IF function | Excel Discussion (Misc queries) | |||
need function/formula help!! | Excel Worksheet Functions | |||
A formula/function to return a formula/function | Excel Worksheet Functions | |||
IF formula with MAX function | Excel Discussion (Misc queries) |