Forum Discussion
Formula for using integral values in a chart, blank spaces, and looking for overall concordance.
SEAK1 See if the attached file has everything as it should be. If not, let me know.
SEAK1 You have me confused now, but that may just be Excel terminology. A1 is the cell in the first column (A) on the first row (1). Thus A2 is the cell directly below it. I assume that the pairs you want to examine are on the same row. ER% from A1 and EP% from B1. Correct?
With regard to the concordance formula I'm still not sure about the logic. Let's not talk about cell references, but say it in words. This is what I think your example is saying:
- If both ER and EP are greater than 1, then Yes.
- If either one of ER or EP are less than 1 (and that includes zero), then No.
but if both ER and EP are zero your schedules suggests a Yes. That I don't get. Perhaps I'm just slow. Sorry. Perhaps you can clarify that bit and correct me where I go wrong.
Hi Riny,
Sorry about that. You are absolutely correct, it is much better for me to say it in text.
-- If both ER and PR are greater than or equal to 1, then “Yes” Concordance.
-- If both ER and PR are less than 1 (including zero), then “Yes” Concordance.
-- If ER greater or equal to 1, and PR < 1 (including zero), then “No” Concordance.
-- If ER < 1 (including zero), and PR greater or equal to 1, then “No” Concordance.
-- If “Blank” space, then leave “blank” space in the Concordance column.
--Finally, calculate the overall Concordance at the bottom of the third column…..
Number of “Yes” divided by total number of “Yes” and No”, and express as a “percentage Overall Concordance”.
I hope this helps. Again, Riny, I really appreciate your kindness in helping me with this.
Best Regards,
Steve
SEAK1 See if the attached file has everything as it should be. If not, let me know.
- Hi Riny,
Your formula worked perfectly and gave me the results I needed! There is no way I would have been able to figure it out with your help! I really appreciate it! If I can help you in any way, please feel free to contact me. Thank you again!
Best Regards,
SteveSEAK1 Glad I could help!