if and or nested

  1. C

    Already functioning calc, Just can't figure out this last required addition.

    Hi excel gurus!!!! I had to re register after years on this site then due to inactivity during disability, my account here was suspended. Grateful to finally get back in amongst the brainyacks. I am helping an anonymous group and designed an excel sheet tracking their home group members status...
  2. H

    Clean data help - remove rows

    Hi! I'm trying to clean a dataset and only retain families with at least parent at home. I started going through it manually but it took 7-8 hours to do 3,000 entries and I have 30,000 entries left to do! There must be an easier way so I figured I'd add the criteria here and maybe someone...
  3. J

    Two conditions most be met for each or

    I HAVE 4 OUTCOME COMBINATIONS. I couldn't figure it out. it only changed if all three B:E exceeded 84, but I need to change if any of the cell exceeds 84, along with A1 IF A1 IS LESS THAN 1, AND any if these cells exceed B2>84 OR C2>84 OR D2>84 OR E2>84 ="A" IF A1 IS LESS THAN 1, AND any if...
  4. T

    How to convert this conditional excel formula to VBA code ??

    Hello All, I've got a perfectly working Macro assigned to a button to copy paste the contents from one sheet (Designed like a form) to another sheet (Master database - Locked and Protected). This workbook will be shared with many people to fetch data from each. Now, I want my user not to leave...
  5. L

    Multiple IF AND in same formula

    Hi I'm trying to create a formula to deliver three different outputs based on conditions of three columns. Conditions: IF a2 = 11 AND d2 = 028 return NI Landline OR IF a2 = 11 AND c2 = 07 return Mobile OR IF a2 <>11 return Other Number It;s necessary to check Col C...
  6. A

    How do i nested IF AND OR with unique values and unique message

    Hi, Cell E3 display dynamic reference values between 000 to 333 ( e.i 000,001,002,003, etc,etc) Each reference have their "own" measure values that is displayed on cells F3,G3,I3,R3,T3 for example ...
  7. N

    OR and wildcards

    =IF(OR(B4={"1A","1B","2A","2B","18A","18B"})... Is it possible to change this so that all it does it look for A or B in cell B4?
  8. K

    Copy lines of other sheets based on criteria entered into two cells

    Hello! I am trying to see if there is a way to achieve my idea without nesting IF AND/IF OR statements in the formula bar. I am not too familiar with VBA, but I imagine there is some code that could help me with the following goal: I am creating an excel workbook database that will allow users...
  9. A

    Function IF AND OR (main Value cell) nested to multiples cells to get exact Result

    Hi, I trying to display depending on values from Main cell (cell C) nested with Multiples cell, so far a i have good result but i still need to add a criteria on more cells with some values. i made a short formula that is working ...

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