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