2003

logical_value

valu_if_true

value_if_false

IF

2003

lookup_value

table_array

col_index_num

range_lookup

VLOOKUP

2003

text

start_num

num_charsm

MID

2003

reference

rows

cols

height

width

OFFSET

2003

logical_1

[logical_2]

[…]

XOR

2003

text1

[text_2]

[…]

CONCATENATE

2003

value

format_text

TEXT

2003

lookup_value

table_vector

result_vector

LOOKUP

2021

lookup_value

lookup_array

return_value

if_not_found

match_mode

search_mode

XLOOKUP

365

text

col_delimiter

row_delimiter

ignore_empty

match_mode

pad_with

TEXTSPLIT

2021

rows

columns

start

step

SEQUENCE

2021

array

incloude

if_empty

FILTER

2021

array

sort_index

sort_order

by_col

SORT

2003

find_text

within_text

start_num

FIND

2003

find_text

within_text

start_num

SEARCH

2003

[reference]

COLUMN

2003

logical1

[logical_2]

[…]

OR

2003

logical1

[logical_2]

[…]

AND

2003

[reference]

ROW

2003

range

criteria

sum_range

SUMIF

2003

index_num

value1

[value2]

[…]

CHOOSE

2003

ref_text

[a1]

INDIRECT

2007

sum_range

criteria_range1

criteria1

…

SUMIFS

2003

number

ABS

2019

logical_test_1

value_if_true_1

[…]

IFS

2003

array

row_num

column_num

INDEX

2003

text

old_text

new_text

instance_num

SUBSTITUTE

2003

database

field

criteria

DGET

2003

value

N

2003

array

ROWS

2003

text

LEN

2003

number

INT

2003

logical

NOT

2003

number

ISEVEN

2003

number

ISODD

2003

number

EVEN

2003

number

ODD

نمایش اولین و آخرین تاریخ فروش

XLOOKUP

SORT

SORTBY

استخراج نام فایلها و پوشه ها در اکسل

TEXTSPLIT

SUBSTITUTE

FIND

نمایش نتیج بر اساس تاریخ ، لایفو و فایفو

VLOOKUP

SORT

IF

FILTER

نفرات اول لیست با شروط مختلف

XLOOKUP

IF

INDEX

جمع فروش 3 ماهه 

OFFSET