Nested If function with a and function

[wyatt356]

Hello all,

Running into a problem with this nested if. For some excel stopped using color coded parentheses but Im pretty sure I used the right amount but its hard to keep track. Anyways any help is appreciated Thanks!!!Screen Shot 2018-06-05 at 12.39.56 PM.pngScreen Shot 2018-06-05 at 12.39.31 PM.png

[AliGW]

Attach the workbook, not a picture of it, please.

[wyatt356]

Sorry. Heres the entire file ExcelHelp.xlsx

[wyatt356]

And I added the comma at the beginning of the formula just to save file

[Sam Capricci]

what is it you are trying to do with this portion here?
'=IF(AND(B2>=(D2-E2),B2<=(D2+E2)),"Steady",IF(AND(B2>(D2+E2),B2<=(D2+2(E2))),"Growing",IF(AND(B2<(D2-E2),B2>=(D2-2(E2))),"Shrinking",IF(B2>(D2+2(E2),"Growing Extremely,IF(B2<(D2-2(E2)),"Shrinking Extremely")))))
is it supposed to be 2 times E2? or 2 plus E2?

[wyatt356]

Its supposed to be a statistical analysis, so it was supposed to be the mean plus 2 times the standard deviation. So it should be 2 times E2

[Sam Capricci]

well a couple problems I saw were, one was that part needed to be 2*E2, the next, you missed a quote at the end of "Growing Extremely", and another is that you have the formula posted in cell E2 and you have E2 as part of the formula.
this may be closer to what you need but it will return 0 if it is left in cell E2
=IF(AND(B2>=(D2-E2),B2<=(D2+E2)),"Steady",IF(AND(B2>(D2+E2),B2<=(D2+(2*E2))),"Growing",IF(AND(B2<(D2-E2),B2>=(D2-(2*E2))),"Shrinking",IF(B2>(D2+(2*E2)),"Growing Extremely",IF(B2<(D2-(2*E2)),"Shrinking Extremely","")))))

[wyatt356]

I deleted the first column because it had some information on there and I was trying to keep this anonymous. That is why the formula was shifted over one column, but everything else thank you

[Sam Capricci]

Does post #8 mean that the issue is resolved (based on whatever cell location adjustments you need to make)?

[[email protected]]

Hi All,

Not sure if I'm at the right place, but I have a question regarding filling in the values of a matrix. See table.Matrix.PNG

Expectation: Scores showing 1-5 depending on the values of the x and y axis.

Example in the table shows that a 100% Audit and 100% Accuracy gets a score of 5 (from a range of 1-5, where 5 is the highest).

Any help will surely be appreciated.

Thanks!
Paul

[Sam Capricci]

Paul, welcome to the forum. Unfortunately this is NOT the right place to ask a question that isn't related to the question being posted by wyatt356. Forum rules (linked on the home page and subforum pages) are that you don't post your problem on the post of another person. Please start your own post and if you feel what is discussed here then you can link to it.
Thank.

[[email protected]]

Thanks for the guidance, Sambo kid.

[AliGW]

Correct! Paul - please start your own thread.

[wyatt356]

Yes sambo Kid. Your solution worked. Thank you for the help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.