Forum Discussion

Copper Contributor

Apr 06, 2020

Troubleshooting a published Excel formula

I want to use a formula to calculate gain scores that was published in a journal article (https://aapt.scitation.org/doi/pdf/10.1119/1.2372468). The formula is: =IF(A2<B2,(B2−A2)/(100−A2),IF(AND(A2...

excel

Formulas and Functions

mlmat184

Copper Contributor

Apr 06, 2020

Abiola1 Thanks, but I don't have experience with Pivot Tables. Just need to finish this one calculation to finish a manuscript on a consulting job...but I will look at Pivot Tables after this job. Thanks for the suggestion.

Abiola1

MVP

Apr 06, 2020

Hello,

PivotTable is very easy to use and understand than formulas. If you can upload the file or a sample one, I can easily create the Pivottable for you

mlmat184
Copper Contributor
Apr 06, 2020
Abiola1 Thanks for the offer but I'm doing this on a consulting basis and am not authorized to share the data.