SOLVED

The Ref! error

%3CLINGO-SUB%20id%3D%22lingo-sub-2302880%22%20slang%3D%22en-US%22%3EThe%20Ref!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302880%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3BI'm%20working%20on%20my%20uni%20assignment%20within%20excel%20and%20am%20using%20the%20CAPM%20formula%20to%20work%20out%20the%20expected%20return%20of%20the%20market%20data%20I%20have%20inputted.%20The%20calculation%20is%20as%20follows%20%3DM124%2BM123(M122-M124).%3C%2FP%3E%3CP%3EThis%20brings%20up%20the%20REF!%20error.%20None%20of%20the%20info%20within%20the%20cells%20has%20been%20copied%2Fcut%20there%20and%20I%20cant%20see%20another%20reason%20why%20its%20coming%20up.%20M123%20%2BM122%20are%20data%20calculations%20and%20M124%20is%20just%20a%20number%20that%20I%20entered.%3C%2FP%3E%3CP%3EI%20have%20also%20screenshot%20the%20excel%20page%20if%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EKofi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2302880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302954%22%20slang%3D%22en-US%22%3ERe%3A%20The%20Ref!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302954%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039692%22%20target%3D%22_blank%22%3E%40KFOSSU99%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DM124%2BM123*(M122-M124)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302962%22%20slang%3D%22en-US%22%3ERe%3A%20The%20Ref!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302962%22%20slang%3D%22en-US%22%3EYeah%20thats%20worked!%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20i%20appreciate%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2303266%22%20slang%3D%22en-US%22%3ERe%3A%20The%20Ref!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2303266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039692%22%20target%3D%22_blank%22%3E%40KFOSSU99%3C%2FA%3E%26nbsp%3BYou're%20welcome!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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-M124).

This brings up the REF! error. None of the info within the cells has been copied/cut there and I cant see another reason why its coming up. M123 +M122 are data calculations and M124 is just a number that I entered.

I have also screenshot the excel page if this helps.

 

Regards,

Kofi

3 Replies
best response confirmed by KFOSSU99 (New Contributor)
Solution

@KFOSSU99 Perhaps like this:

=M124+M123*(M122-M124)

 

Yeah thats worked!

Thank you i appreciate it.

@KFOSSU99 You're welcome!