Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR statements
Hi. I would appreciate any you might give with this multiple IF formula. I
am trying to compare the first few letters in Cell B15 to certain cells (words). If B15 contains these characters, then I want to perform a calculation, if it does not match, it should check the next condition (word). This is what I've been trying to do so far but it is not working. The first IF condition works alone but after I've added multiple if statements I am getting a #value error. Maybe I do not have the right parentheses? =IF(ISNUMBER(FIND("Prin",B15)),F15*B2), IF(ISNUMBER(FIND("Grad",B15)), F15*B4), IF(ISNUMBER(FIND("Under",B15)), F15*B5 ...If none of these conditions, then it should =B2. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR statements
Hi!
Maybe I do not have the right parentheses? Yep! Try this: =IF(ISNUMBER(FIND("Prin",B15)),F15*B2,IF(ISNUMBER( FIND("Grad",B15)),F15*B4,IF(ISNUMBER(FIND("Under", B15)),F15*B5,B2))) Side note: FIND is case sensitive. SEARCH is not. Biff "Loraloo" wrote in message ... Hi. I would appreciate any you might give with this multiple IF formula. I am trying to compare the first few letters in Cell B15 to certain cells (words). If B15 contains these characters, then I want to perform a calculation, if it does not match, it should check the next condition (word). This is what I've been trying to do so far but it is not working. The first IF condition works alone but after I've added multiple if statements I am getting a #value error. Maybe I do not have the right parentheses? =IF(ISNUMBER(FIND("Prin",B15)),F15*B2), IF(ISNUMBER(FIND("Grad",B15)), F15*B4), IF(ISNUMBER(FIND("Under",B15)), F15*B5 ...If none of these conditions, then it should =B2. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR statements
Bif,
Thanks for the quick response...the formula works now. Those nasty parentheses! Also thanks for the tip about SEARCH. I think I'll use it instead. Much obliged. Loraloo "Biff" wrote: Hi! Maybe I do not have the right parentheses? Yep! Try this: =IF(ISNUMBER(FIND("Prin",B15)),F15*B2,IF(ISNUMBER( FIND("Grad",B15)),F15*B4,IF(ISNUMBER(FIND("Under", B15)),F15*B5,B2))) Side note: FIND is case sensitive. SEARCH is not. Biff "Loraloo" wrote in message ... Hi. I would appreciate any you might give with this multiple IF formula. I am trying to compare the first few letters in Cell B15 to certain cells (words). If B15 contains these characters, then I want to perform a calculation, if it does not match, it should check the next condition (word). This is what I've been trying to do so far but it is not working. The first IF condition works alone but after I've added multiple if statements I am getting a #value error. Maybe I do not have the right parentheses? =IF(ISNUMBER(FIND("Prin",B15)),F15*B2), IF(ISNUMBER(FIND("Grad",B15)), F15*B4), IF(ISNUMBER(FIND("Under",B15)), F15*B5 ...If none of these conditions, then it should =B2. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR statements
You're welcome. Thanks for the feedback!
Biff "Loraloo" wrote in message ... Bif, Thanks for the quick response...the formula works now. Those nasty parentheses! Also thanks for the tip about SEARCH. I think I'll use it instead. Much obliged. Loraloo "Biff" wrote: Hi! Maybe I do not have the right parentheses? Yep! Try this: =IF(ISNUMBER(FIND("Prin",B15)),F15*B2,IF(ISNUMBER( FIND("Grad",B15)),F15*B4,IF(ISNUMBER(FIND("Under", B15)),F15*B5,B2))) Side note: FIND is case sensitive. SEARCH is not. Biff "Loraloo" wrote in message ... Hi. I would appreciate any you might give with this multiple IF formula. I am trying to compare the first few letters in Cell B15 to certain cells (words). If B15 contains these characters, then I want to perform a calculation, if it does not match, it should check the next condition (word). This is what I've been trying to do so far but it is not working. The first IF condition works alone but after I've added multiple if statements I am getting a #value error. Maybe I do not have the right parentheses? =IF(ISNUMBER(FIND("Prin",B15)),F15*B2), IF(ISNUMBER(FIND("Grad",B15)), F15*B4), IF(ISNUMBER(FIND("Under",B15)), F15*B5 ...If none of these conditions, then it should =B2. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating my own user defined function help statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
How do I sum percentages calculated from IF statements? | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |