nested if using and

  1. B

    Nested IF statement for drilling depth and type

    I am trying to have Excel calculate a drilling depth based on type of drilling chosen (ranges below) and to combine types if required. The first range (HTW) below is easily done with nested if's. However, the second range needs to build on the first (ie: below HQ/NTW would begin at 259) or...
  2. V

    Nested IF,AND, OR

    Hey All, I am trying to nest a function using the following formula IF(OR(AND(AN4>=AM4),J4<=0,K4<=0,),"TRUE","NONE") I am getting a result, but the result is not what I need. I want the formula to read as 'If AN4>=AM4, AND either J4<=0, OR K4<=0, then "TRUE, if not then "NONE".' Any input...
    • voltrader
    • Thread
    • nested "if statements" nested and statementes nested if or and multiple nested if using and
    • Replies: 3
    • Forum: Excel Questions
  3. H

    Nested IF statements using AND

    Hi all! I'm fairly new to the Excel game and I haven't been running into many problems -- when I do, a quick look through Google or Reddit has pretty much been able to solve my issues. I'm hoping you can help with my latest frustration! I'm running Excel 2011 on Mac. I'm creating a...

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