Forum Discussion

KFOSSU99's avatar
KFOSSU99
Copper Contributor
Apr 28, 2021
Solved

The Ref! error

Hi,  I'm working on my uni assignment within excel and am using the CAPM formula to work out the expected return of the market data I have inputted. The calculation is as follows =M124+M123(M122-M12...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 28, 2021

KFOSSU99 Perhaps like this:

=M124+M123*(M122-M124)

 

  • KFOSSU99's avatar
    KFOSSU99
    Copper Contributor
    Apr 28, 2021
    Yeah thats worked!

    Thank you i appreciate it.

Resources