Help with Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1653362%22%20slang%3D%22en-US%22%3EHelp%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1653362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20(10.PNG%22%20style%3D%22width%3A%20684px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217544i522B95986138A3F2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excel%20(10.PNG%22%20alt%3D%22Excel%20(10.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epls%20help!!%20I%20am%20facing%20difficulty%20with%20the%20formula%20in%20solving%20this%20question%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1653362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1653683%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1653683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789061%22%20target%3D%22_blank%22%3E%40xuananan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20wrote%3A%20%3CEM%3Epls%20help!!%20I%20am%20facing%20difficulty%20with%20the%20formula%20in%20solving%20this%20question%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20first%20thing%20that%20needs%20to%20be%20said%20is%20that%20you%20should%20NOT%20be%20trying%20to%20construct%20%22the%20formula.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%2C%20as%20the%20assignment%20says%2C%20%22construct%20a%20%3CU%3E%3CSTRONG%3Espreadsheet%3C%2FSTRONG%3E%3C%2FU%3E%20%3CU%3E%3CSTRONG%3Emodel%3C%2FSTRONG%3E%3C%2FU%3E%20of%20your%20savings%20for%20the%20next%2020%20years.%22%20It%20goes%20on%20to%20say%2C%20%22sketch%20the%20Influence%20diagram%22%20--making%20it%20sound%20as%20if%20%22influence%20diagrams%22%20may%20be%20something%20you've%20been%20introduced%20to%20in%20your%20class.%20%5BThis%20is%20a%20class%20assignment%2C%20right%3F%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I'd%20suggest%2C%20quite%20seriously%2C%20forget%20about%20%22a%20formula%22%20for%20the%20moment.%20Sketch%20out%20on%20a%20piece%20of%20paper%20or%20white%20board%2C%20all%20of%20the%20factors%20here...create%20a%20table%20of%20what%20is%20going%20to%20add%20money%20each%20year%2C%20what's%20going%20to%20cost%20money%20each%20year%2C%20how%20you%20might%20put%20all%20that%20together%20in%20year%201%2C%20then%20year%202%2C%20then....so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20part%20is%20relatively%20easy.%20%3CU%3E%3CEM%3E%3CSTRONG%3EFirst%20you%20have%20to%20think%20about%20this%20in%20a%20big%20picture%20way.%20And%20THAT%20is%20what%20your%20assignment%20is%20concentrating%20on.%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Excel (10.PNG

 

pls help!! I am facing difficulty with the formula in solving this question 

1 Reply
Highlighted

@xuananan 

 

You wrote: pls help!! I am facing difficulty with the formula in solving this question

 

So the first thing that needs to be said is that you should NOT be trying to construct "the formula."

 

Instead, as the assignment says, "construct a spreadsheet model of your savings for the next 20 years." It goes on to say, "sketch the Influence diagram" --making it sound as if "influence diagrams" may be something you've been introduced to in your class. [This is a class assignment, right?]

 

So I'd suggest, quite seriously, forget about "a formula" for the moment. Sketch out on a piece of paper or white board, all of the factors here...create a table of what is going to add money each year, what's going to cost money each year, how you might put all that together in year 1, then year 2, then....so on.

 

The formula part is relatively easy. First you have to think about this in a big picture way. And THAT is what your assignment is concentrating on.