# nested and statementes

1. ### Nested statement help

I am trying to create a nested IF statement to look at a cell and do 3 things: 1. look to see if cell is blank, if so leave blank, 2. date in cell- todays date is < 30 print" DUE" in cell. 3. look to see if cell has NA typed in the cell, if so leave blank My code works in terms of the...

Hello... I work as a Quality Assurance Analyst and I am needing assistance with coming up with a very complicated nested formula. I am creating an "accountability" track sheet for Agent's audit scored for each month. Here is our workflow with their Supervisors/Management: - Agent's monthly...
3. ### Dividing Nested IF/AND sum

Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...
4. ### 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...
5. ### Nested Formula ??

I have three Columns Type Discount Rate In the type column It is either "Family" or "Single" In the discount column it is either "n/a"= no discount or "edu",or "mil" = 10% discount In the rate column I need a formula that will give me Family= "100" or 10% off = "90" if mil or edu is in the...
6. ### summarize

I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to...

### 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.

### Which adblocker are you using?

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

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