Forum Discussion

mlmat184's avatar
mlmat184
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
Abiola1's avatar
Abiola1
MVP
Apr 06, 2020
Hello,

I believe using PivotTable will make life much easier for you than trying to write complicated formula
mlmat184's avatar
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's avatar
    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's avatar
      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.

Resources