multiple conditions (if

  1. J

    Multiple IF conditions using AND, OR, NOT

    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...
  2. V

    Multiple condition Situation

    Hi all. This is a rather complex situation hopefully someone will be able to help. I have 3 drop down menus as below. Cell A1 -Cell with numbers in 50cm increments from 100 to 1000 Cell B1 - Cell with drop down menu which includes 3 types of rails. Cell C1 - Cell with drop down menu which...
  3. R

    Multiple condition IF(AND, best practices

    I am running into trouble configuring a cell formula that is testing for multiple embedded conditions based on values in 4 separate cells. In fact, it seems that there are perhaps dozens of possible outcomes. I've begun by testing with nested IF(AND( statements. I can see how this could...
  4. M

    Extract Data from Single Cell based on multiple conditions

    Dear All, I have single cell having remarks of work done. I need to extract the data based on two conditions. I'm already using below formula which returns the word in cell but not fulfilling the condition I need. Relay & Capacitor replaced =IF(ISNUMBER(SEARCH("Relay",$T64)), "Relay", "")...
  5. J

    Pull info using multiple criteria (if a1=x AND b1=y then z)

    I have a rather large master spreadsheet containing vacancy information for a number of teams. We've been asked to provide regular drill-owns into the number of vacancies/time open/status updates etc. Is there a way that I can create a new tab for each team that auto-updates linked to the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top