Its pretty easy if you stack your data vertically. They you can call out that row of data in any formula you want. You can also then drag that formula down to get a set of answers with different inputs…
That being said look for help online and try playing with it for a while. Its a pretty useful tool.
lol if I had the time to play I would, but its due in 4hours. I thought it was going to be simple “add data, make graph, ???, profit” but this shit is nuts
Seriously excel is a must in business. The funny thing we have an executive assistant that does all of the formulas and such for all of our projects, I am really bad with that part… but if you tell me that you need a VBA application to make excel do an irish jig i can make it happen! I really don’t get how i have to look up simple tasks, but when it comes to the most complicated workbooks, I can have them done in about an hour (well I have had a project take a week, but that one is a fully customizable file based on the user that logs in and is somewhere around 4 mb.
mrexcel.com is a good help, as is Pearson consulting’s free articles when you are stuck.
I have a series of equations that I need build off each other and the answer of that set goes into the same set of equations, but in a different row. I know if you drag the box down, it will compute the same function but is there a way I can tell excel to take answer from box A, put it in box B, and use box B for the rest of the equations?