So I'm having a heckuva time with Excel. Absolute addressing, relative addressing, mixed addressing, and all these complex formulas and equations. I talked to my professor off-line, and explain to him that I've never use this program before, he told me to avoid YouTube tutorials because they will teach me things I do not need to know for this class. He told me to use the lab program for the course to practice the type of problems were doing. He said eventually it will just click and you will get what's going on. Well after doing problems over and over for hours, it's not clicking yet. And I have no idea why it's doing what it's doing. I love/hate how this online homework program is set up. You have three attempts to answer multiple-choice correctly. After that it asked you the same question again but with different numbers. So of course I got 100% on it because I kept guessing. I want to know how to do this crap. I need to know some of the basics first. This is so embarrassing, LOL I don't understand why the answer is what it is. Sent from my iPhone using Tapatalk
Can you not just open excel and type each formula? Excel is one you need to "play around with" to figure it out. Sent from my SM-G930V using Tapatalk
Yeah that's what I'm doing now. I think I understand the absolute addressing now Sent from my iPhone using Tapatalk
I'm sure this is so basic, but so foreign to me! I do understand absolute addressing now. As long as I & the dollar signs before the column and before the row, whatever Cell I apply that to will stay the same regardless what's in other cells, I get that now. Sent from my iPhone using Tapatalk
The $ locks either the column letter or row number. So if you put in... =$c7, column c will be locked once you scroll your formula. =c$7 row 7 will be locked...=c7 nothing is locked. So as you drag your formula down it will automatically change the cell address. Maybe that helps, maybe it makes it worse lol. Sent from my SM-G930V using Tapatalk
Sorry can't help. I have no idea what the "official terms" mean. I just know how to get spreadsheets to do what I want.
Youtube is my savior for Excel. Your professor may not like it but if you watch it an learn, I don't see an issue with it. But good luck.
This explains it well. Relative & Absolute Cell References in Excel Essentially relative addressing will change as you copy and paste them through out the spreadsheet. Absolute addresses stays consistent. I always ask Uncle Google.
I dont know the official terms but I know how to do all of what you just posted. If statements read like this: =IF(logical test, value if true, value if false).So what he did was called nested IF statements, which means you add another if after the first value if true. You don't need a value if false if you want it to just be left blank. "'s are used to return text for the value. by typing "" you are just telling it to return nothing. Like previously stated, $ are used to lock cells. if you type into A1, = A2 + A3, the value of A2+A3 will show up in A1. If you then copy A1 and paste into B1, the value of B2+B3 will show up in B1. If you copy A1 into C3, the value of C4+C5 will show up in C3, see how it works? but, if you use $ (by toggling the F4 key when you click a cell while typing a formula) you can lock either the row, column, both, or nothing. Say you want the value of A2+A3 to show in A1 and B1, you could then use =$A2+$A3 and that means no matter which column you copy into, it will still be refrencing column A. If you lock the number (row), then that means no matter which row you copy into, it will still refrence rows 2 and 3. so =$A$2+$A$3 into A1 and copied into D4 will show the value of A2+A3 in D4 even though you moved over columns and down rows. Does this help? I use excel and MatLab to find 2nd-4th order transfer functions from graphs and best fit lines and then use that in Matlab to come up with better transfer functions in order to characterize inverters at work, then I go home and make excel sheets to graph trail camera pictures by what type of deer is in the picture based on the month selected and 27 weather variables. <--- that one was 18 pages of nested IF statements, so if you ever want to do something in excel, I have probably either done it or googled how to do it.
