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! |
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 |