-
###
Means that the space is too small
-
Green Triangle
There's something wrong in the formatting
-
#REF!
Cell reference is not valid
-
#Value!
Wrong type of argument or operand in a formula
-
Names with a space in the middle require what?
"quotations"
-
=ROUND(number,num_digits)
- Round function
- Number: number to be rounded
- Num_digits: number of decimal places
- Nearest
-
=countif(range,crieria)
- Range: a continuous range of what your looking for
- Criteria: determines what cells to count.
- Boolean expressions need quotes ">=5"
- Wild card if you want to look for the first 3 letters of whatever that have USA in it "USA*"
- Question mark after the letter would mean it looks for the first 3 letters and then another letter has to be there "USA?" so it would count USAF not USA
- Ampersands are necessary for cell reference ">="&A2
-
=countifs(range, criteria1, range, criteria2)
=countifs(range, what you are looking for, second range, what you are looking for)
-
=sumif(range, criteria, sum_range)
=sumif(range, what to look for, what you want to sum)
-
=sumifs(range, criteria range, criteria, criteria range 2, criteria2)
=sumifs(sum range, criteria range, what you are testing for, another criteria range and what you are looking for)
-
=averageif(range, criteria, [average_range])
=averageif(range you want to look at, the criteria, range it averages if its true)
-
=large(array,k)
- =large(range of numbers you want to look at, which number specifically)
- K: 1 means the largest number, 2 is the second largest
-
=small(array,k)
- =small(range, which number specifically)
- k: 1 means the smallest, 2 second smallest
-
=rank.eq(number, reference, [order])
- =rank.eq(the number whose rank you want to find, range, how to rank number)
- Order: 1 means ascending order, the biggest number is the highest rank (largest number)
-
=not()
- When you want the opposite of what is said
- Keyword "did not"
-
=and
- If there is one thing false, the entire thing is false
- Keywords "all" items have to be true
-
=or
- If one thing is true then the entire thing is true
- Keyword "if" "either"
-
=if(logical test, value if true, [value if false])
If this is true, do this, or else do this
-
if(logical text, value if true, if(logical text, value if true, [value if false]))
=if(this=true, do this, else if(this=true, do this, otherwise do this))
|
|