Ok,
1) In B2
So thats the format you'd use and the second is a nested if for multiple arguments. If you have a whole bunch of different text based on a bunch of different requirements, then you'll probably want to make a helper column.
2)
So here A1 has to not be blank AND not 0 for A3 to display its value. Otherwise it'll display A2. Again, you can do a nested if statement if you need the same checks for A2
3) Just use these examples as help. Also, if you need help understanding a function, hit the fx button located at the top, right in front of the input bar.
4)Don't know. $ is usually used to lock a cell. So saying you used A1 in an equation and you dragged that equation out among multiple cells. If you drag it out to the right, that A1 will change to B1, C1, etc however far you drag. If you locked the cell in the equation by writing it as $A$1, then no matter how you drag it out, it won't change.
5) Using that Insert Function Window (by pressing the fx button) should help you a lot when trying to find the functions you want to use and how to use them. Even going into the help menu will often give examples of each.
Bookmarks