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.
Hi Riny,
Thank you so much for your very prompt and kind reply! The formula you suggested to calculate the "concordance score" is very helpful.
With regards to your question, we are looking at breast tumor percentage nuclear ER and PR reactivity in tissue biopsies. The cutoff of 1% is positive. When a patient has <1% expression, we are saying that only rare tumor cells are positive, but since the value is less than 1% of the area examined, it is reported out as being Negative. In contrast, when tumors are 1-100%, they are considered positive. I was wondering if there was a way to write a formula so the concordance can be determined by Excel. Something like....
A1 is the ER column, and A2 is the PR column.
=IF(A1>=1 and A2>=1, IF(A1=0 and A2 = 0, IF(A2<1 and A2<1))), "Yes", "No"
but that did not work. Any suggestions would be really appreciated. Thank you Riny!
Sincerely yours,
Steve
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,
Steve