Please enable JavaScript.
Coggle requires JavaScript to display documents.
CALCULATIONS PART :three:: (TEXT 8:61 (TRIM (TEXT) (REMOVE (SPACES…
CALCULATIONS
PART :three::
8:62
SUMIF
ADD
CELLS
BY
CRITERIA
(range , criteria , [sum_range])
sum_range
WHEN
DIFF
RANGE
TO CHECK
CRITERIA
:fishing_pole_and_fish:
HOURS
EACH
MONTH
SUMIF(
MONTH_RANGE (1 - 12)
,
CRITERIA (1, THEN 2 etc...
,
HOURS_WORKED_ALL_YEAR_BY_DAY_RANGE
)
8:59 LOOKUP
VLOOKUP
( lookup_value , table_array , col_index_num, [range_lookup])
col_index_num
INFO
BRING
IN
START
INDEX
1
OF
SELECTED
1 more item...
range_lookup
MATCH
FALSE.
EXACT
TRUE
APPROX.
:!!:lookup_value
MUST
FIRST
COLUMN
IN
table_array
i.e
1 more item...
HLOOKUP
SIMILAR
VLOOKUP
SEARCH
ROW
lookup_value
(lookup_value , table_array , row_index_num , [range_lookup])
FIRST
ROW
NEED
BE
WHERE
LOOK
MATCH
OF
SELECTED
ARRAY
8:60 DATE
DAY
1 - 31
MONTH
:fishing_pole_and_fish:
MONTH( 1 - JAN)
GIVES
1
YEAR
:fishing_pole_and_fish:
2014
CAN
TAKE
DATE
SEPERATE
COMPONENTS
WITH
THESE
:three:
DATE DIFFERENCE CALCULATION
:fishing_pole_and_fish:
.
.
10 JAN - 1 JAN
GIVES
9
BUT
=
10
SO
ADD
1
ADD
1
TEXT
8:61
LEN
(
TEXT
)
NUMBER
CHARACTERS
TRIM (TEXT)
REMOVE
SPACES
BEGIN
END
MULTIPLE
BTW
WORDS
EXCEPT
SINGLE
SPACES
BTW
WORDS
:fishing_pole_and_fish:
D
3_SPACES
G
D
1_SPACE
G
RIGHT
(
TEXT
,
NUMBER
)
BRING
CHARCTER
FROM
WORD
END
:fishing_pole_and_fish:
HELLO
RIGHT("HELLO", 2)
LO
LEFT (NUMBER)
FIND
(
find_text, within_text, [start_num]
)
START_NUM
DEFAULT
BEGINNING
1
FIRST
MID
(
text, start_pos, num_chars
)
RETURN
CHARACTER
MIDDLE
OF WORD
PARAM
START
POS
LENGHT
CONCATENATE
(
text_1, text_2, text...
)
JOIN
TEXTS
INTO
ONE
REPLACE
(
old_text, start_num, num_chars, new_text
)
PART
OF
TEXT
WITH
ANOTHER