if and if then

  1. J

    How to get the value in multiple criteria of two columns ?

    I have data in Sheet1 and in Sheet2. I have three columns in Sheet1 Bank, Branch,Branch Code in A B & C column. In sheet2 I have Bank Branch Code in A B & C column In C2 of Sheet1 I want that IF A2 and B2 matches the criteria it will get the Branch code from sheet2 Range A2:C100. For example...
  2. J

    excel If and Formula

    I want a formula that If J1 is less than 1000 and H1>0 and I1>0 then the value should be 1000-J1 else 0. I am trying this formula but getting error. =IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)
  3. J

    How to select Exact values under Dependent Rows?

    for example I have two Sheets "DATA" "RAW DATA" In DATA sheets <tbody> APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 ORANGE 111 </tbody> In RAW DATA sheet in Column B I have to input APPLE/BANANA/ORANGE in various rows. I...
  4. J

    Excel Check Vlookup value if cell value matches

    I have two Sheets "DATA" "RAW DATA" In DATA sheets Column A COLUMN B APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 In RAW DATA sheet in Column B I have to input...
  5. E

    Help for formula to find Top 3 value in excel

    Dear Experts, I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like- Sheet1 <tbody> Group Name Value 1 Nashid 200145 2 Kashem 188516 1 Jabed 184198 2 Rubel 172569 3 Romel 168251 1 Eman 156622 2 Hasin 152304 3 Nasim 136357...
  6. K

    Nested "IF AND THEN" - Need expert guidance please!

    I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist... I'm building a scheduler for a team of 200+ individuals. I have 50K rows of data with a large number of columns. I'm trying to build a...
  7. W

    Can I create an "If and If, then" for two drop down fields with PARENT values to get the CHILD Values? Quilt?

    I'm trying to figure out how to select two values from a drop down list and then to to a table on another tab to pull out a sub value. I have SIZE as a drop down (pulling from a named range) I have COLOR as a drop down (pulling from a named range of parent colors, which have child colors)...

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