if multiple conditions

Hi, how do I test 2 conditions where one condition has 2 possibles? In Row _ , IF Column A contains "CALL", AND Column B contains "Buy" or "Acquisition", enter result in Column F A B C D E F Result Buy company1 40 157.870 (6,321.80) CALL Buy CALL-100...

Data: Row A B C D E 1 Acquisition CALL Joheen -3,000.00 3,000.00 2 Buy CALL Cure -5,266.50 5,266.50 3 Buy Afterburn -619.50 Formula not working: =IF(ISNUMBER(SEARCH("Acquisition",$A1))*OR(ISNUMBER(SEARCH("Buy",$A1)))*NOT(ISNUMBER(SEARCH("CALL",$B1))),-$D1,"") I want to...

Hi all, I am trying to figure out the best formula for this problem. My workbook is more complicated, but in a nutshell here is what I'm trying to create a formula for: Data Tab <tbody> ANIMAL COUNT Cats 18 Dogs 245 Rabbits 17 </tbody> Animals tab <tbody> Cats Y Dogs N Bears Y...

Hello, I was hoping someone could please help with a multiple conditions formula? I am trying to use two criteria to produce a result, I was initially using "IF and OR" but because I was using postcodes and was trying to match on the first two characters am now using SUM(COUNTIF {** **} as I...

Hi all, I am after a formula that compares figures in cells to each other and if they match will give me a TRUE response or FALSE if they don't. For example; Cell A54 must match with A54 on worksheet 2, but as must 4 other cells, say B54, C54, D54, E54 match to the corresponding cells on...