nested if and statements

  1. D

    Writing Nested If formula which returns "0" once condition is met

    Hello, I have a nested if statement to return values once a certain number of units are deployed. What I'm having trouble with is how to structure the formula so that is returns zero once the condition is met. So for instance, the first time units deployed hits the 23-28 range, then return...
    • Dgetske
    • Thread
    • deployed nested if and statements return statement units
    • Replies: 7
    • Forum: Excel Questions
  2. J

    Help with logic please!

    Hi all I am struggling with nested IF statements to get the logic correct for the following problem: I am trying to calculate forward forecast consumption. There are some rules which need to be observed. Assume whole week buckets. Sales orders consume forecast for current week and or...
    • Jat999
    • Thread
    • change nested if and statements results sales week
    • Replies: 7
    • Forum: Excel Questions
  3. R

    If-else statements for multiple columns

    Hi, Need a formula for showing value of a cell as follows: if cell value = value in cell a1, then show value in cell b1, else if cell value = value in cell a2, then show value in cell b2, else if cell value = value in cell a3, then show value in cell b3 and so on. <tbody> Value (input) A B...
    • R3da1ert
    • Thread
    • if else if elseif nested if nested if and statements
    • Replies: 2
    • Forum: Excel Questions
  4. D

    nested if with and statements

    Hi! I need help.. I have a table that on cell f4 is a due date, g4 is the completed date, a1 is todays date (today func) , now in j4 i want it to read wether the project was complete, past due and if no due date was selected i need j4 to remain blank. Summary.. If f4 is blank = j4 blank If g4...

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