nested if or and

  1. P

    User Form Calculation (Out of Stack Space)

    Hello - I am having an issue with my user form code. I am receiving an (Out of stack space error) The following code is pushing data entered into the user form to the corresponding excel file in order to calculate values derived from these inputs and then returning the calculated values back...
  2. tycasey17

    IF with nested AND and OR statements

    <tbody> Name Rank ID# Code Status Gender Issue ORD DT Coat Pants Skirt SS Shirt LS Shirt Doe, John SGT 12345 TT TPU Male 30xs 26s 14.5 13.5 x 32/33 Doe, Jane PV2 67890 AA TPU Female 2015-1-1 8WR 8WR 8WR 8R 8R </tbody> ISSUE Column needs to have one of the six possible entries: NI...
  3. M

    Nested multiple IF, AND & OR is returning #VALUE!

    I'm having difficulty executing an IF, AND & OR nested statement. I want to calculate a simple payback that includes an incentive amount. There's a drop-down cell, K64, that has five choices. Depending on what is selected it either references dollar amounts in either Q64 or U64 and compares it...
  4. L

    Nested IF formula to pick up data from changing range

    Hi, i have a worksheet that will be constantly updated. In C60:CH60 i have an if formula which looks at newly added data (in D100:DH100) and updates the data in C60:CH60 to the most recent data inputted in D100:DH100. If there is no new data, i have it returning the sum of data from a table...

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