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