Formulas

Question

I am MS 365 Family user.&nbsp;Sometimes formulas work but if I touch it w/o changes it stops working.&nbsp;Could someone please point me in the right direction to help me understand how to add, get into and out of changing formulas in cells with stock history formulas.&nbsp; I then add another row with a date and copy down formulas to see which way my investments are going.&nbsp;My formulas in the attached have worked in the past but I keep breaking them somehow when I go to add another row.&nbsp; I believe that I am missing a key piece of maybe some editing information and returning back to execute the formula(s).&nbsp; I also suspect that I am improperly&nbsp; using “ctrl enter”, the “f4” key, the “f2” key, the “escape” key and perhaps more. &nbsp;I am 75 and getting a little slower than I used to be.&nbsp; Is there a good tutorial?&nbsp;I would like to know more about when and how to use these keys and more to make everything work.&nbsp;And, what do I do to make the attached work where the formulas are in rows 16 through 25?&nbsp;Please help.Thank you in advanceSteve Lorentzenmailto:stevelorentzen@comcast.net

jkpieterse · Answer

SteveL50&nbsp;Can you perhaps upload a version of that file that contains bits that do not work? The formulas look just fine to me.

stevel50 · Answer

Thanks for responding back to me.The attached excel file is the spreadsheet that does not work for me. Are you not receiving the attachment or is the file corrupt?Any help would be appreciated.Steve Lorentzenstevelorentzen@comcast.net

peterbartholomew1 · Answer

SteveL50&nbsp;The sheet updated fjust fine for me.&nbsp; Still worked when I introduced names to avoid relative referencing.= STOCKHISTORY(Stock, Date, Date, 0, 0, 1) * QtyThe formula spilt as an dynamic array without issue.

stevel50 · Answer

Peter, thanks for the reply. Unfortunately for me I'll need more info. Could you spell out in detail how you go about making it update. Assume I know nothing about working with spreadsheets (which is pretty much true). Spell out like left click on cell b48 press enter, ctrl enter, f4, or whatever. There is something in my knowledge that I am missing in working with cells or formulas that is preventing me from making this work. Something will click for me that will help me to solve my problem.Thanks for your help.Steve Lorentzenstevelorentzen@comcast.net

peterbartholomew1 · Answer

SteveL50&nbsp;Sorry but, for me, the formula just works.&nbsp;&nbsp;There may be issues with the version of 365 or its update status but others are more qualified than I to comment.&nbsp;&nbsp;JKPieterse&nbsp;

Forum Discussion

Formulas

8 Replies