Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
=ROUND
= ROUNDUP =ROUNDDOWN |
=ROUND(cell or formula,digit)
-digit = 0 All decimals become "0". -digit = -2 Rounds to the hundreds position. This rounds up to "2" places - ie the closest 100 so 234 becomes 230. -digit = 2 Rounds up to "2" decimal places (RHS) - ie 10.342 becomes 10.34. |
|
=mROUND |
=mROUND( number, multiple)
This function rounds off to nearest number or amount you specify eg for pricing
eg mROUND (cellx,7) This will round up or down to a number divisible by 7 - digit = 23 This will make the function divisible by 23 -digit = 0.05 This will round up or down eg 0.33 becomes 0.35. |
|
=TRUNC =INT =ODD =EVEN |
=TRUNC(NUMBER OR CELL OR FORMULA)
Both TRUNC and INT throw away the decimal numbers. They lower the value of a number. - Diference: INT will select the higher negative number while TRUNC selects the lowest - eg -17.34 TRUNT = -17 while INT selects -18.
ODD and EVEN will select the highest interger number
|
|
=MOD
This function returns what is left over. It gives us the remainder after cell1/cell2.
|
=MOD(cell1,cell2) -cell1 = 25, cell2 = 12. -It will return 1. This function tells us what is left over when we divide. It calculates the leftover items. - eg 125 products packaged into 8 containers and using =MOD(125,8) = 5 (ie 125/8 = 15 and 5 products are left over)
|
|
=MOD
other uses |
Can use this formula for conditional formatting. It will select every fifth row and hightlight eg =mod(row(),5)=0
|
|
ROW() |
This refers to the current cell |
|
RAND RANDBETWEEN |
RAND() - This formula will generate random numbers
RANDBETWEEN(number or cell,number or cell)
You can specify the range of numbers eg 0 to 1 or you can include a date eg cell1 = 1/1/15 and cell2 = 31/12/15
|
|
CONVERT |
=CONVERT(cell or number,"from x unit","to z unit")
eg =CONVERT(cell or number,"km","mi")
Once you press "," you are presented with selection of units. *NOTE - it does not include km so add k in from of meters - km
|
|
AGGREGATE |
Similar to fx function operation. Allows you to perform a number of operations eg sum, average, std deviation etc AND gives you opportunity to specify rules eg ignore hidden
=AGGREGATE ( operation,rules,Range)
-operation = select number for operation -rules = given options -range = highlight range you want to include
|
|
AGGREGATE |
AGGREGATE(select operation,the rule, the range)
Select operation - add, multiply,divide Rule - presents options such as dont include hidden values, ignore errors Range - select range such as row or column This function allows you to 1. Ignore errors 2. Not include hidden rows 3. Other - such as nested, subtotals, aggregate data |
|
ROMAN ARABIC |
Function converts |