I would like to enter the following formula:
Pratt= beta value x r/Rsquared
so that beta, r, and RSquared are separate cells where I can enter the number and have excel calculate Pratt for me. Any suggestions am a complet noobie at excel.