← → Arrow keys or swipe to navigate pages
Page 1 of 4: Page 1

Pluget Office



Pluget Table

Pluget table use document
Pluget Table fits the users to create tables and can create both regular tables and tables in Pluget Table and Pluget tables are both formulas and commands Pluget table is written into the formulan cell The commands are usually made to be used in the formulat calculations in the Pluget Table thighs, and the command is made to make the user's job easier for the user's work when we write the command and click Run whistle. 

formulas calculation =(account) This formula is slashed to calculate inside the cell, such as, like =(12*98) or =(A4+B9), and in addition, writing the coordinate of the cell and printing the number inside the cell, for example, in the example of =(C4+11)

copy the number in another cell in another cell = (number of the count of the count of the cell) for example, there are 1299 numbers to the D9 cell, and we want to copy this number to the C7 cell at this time we can print the number 1299 in the D9 cell to the C7 cell by typing the number of 129 cells to the C7 cell 

and also in advanced forms

Function Description Sample Usage
SUM
It gives the sum of the given values or cell intervals.

=SUM(A1:A10)


AVERAGE
Calculates the arithmetic average of values.

AVERAGE(B1:B10)


MIN
Returns the smallest value in the given range.

n =MIN(C1:C5)


MAX
Returns the greatest value in the given range.

MAX(C1:C5)


COUNT
It gives the number of cells containing numerical value in December.

=COUNT(A1:A10)


ABS
It calculates the absolute value of the number.

=ABS(A1)


ROUND
Rolls the number according to the specified step sensitivity.

OLUTIONALS(A1, 2)


POWER
Calculates the specified base of the base.

NETWER(A1, 2)


SQRT
It takes the square root of the number.

n =SQRT (A1)


MOD
It gives the rest of its division (module).

=MOD(A1, 2)


PRODUCT
It gives you the product of all the values.

=PRODUCT(A1:A5)


Two. Logical Functions
Function Description Sample Usage
IF
If the condition is correct, it returns the first value, if it's wrong, the second value.

=IF(A1>5, "yes", "no")


And
If all conditions are correct, return TRUE.

=AND(A1>0, B1>0)


OR
TRUE returns at least one of the conditions if it is true.

=OR(A1>10, B1>10)


NOTE
It reverses the logical value.

=NOT (A1>5)


TRUE
Directly produce TRUE logical value.

TRUE ()


FALSE
Directly produces the logical value of the FALSE.

FALSE()


Three. Text (String) Functions
Function Description Sample Usage
CONCAT
It combines multiple texts or cell values.

=CONCAT(A1, B1)


LEFT
It takes the specified number of character of the text from the left.

=LEFT(A1, 3)


right
It takes the specified number of character of the text from the right.

=RIGHT(A1, 3)


MID
From the specified position of the text, it receives as many characters as desired.

=MID(A1, 2, 4)


UPPER
It converts the text into a capital letter.

NETCKET (A)


LOWER
It converts the text into a lowercase.

n =LOWER(A1)


NILE
Calculates the character length of the text.

NIGHTS


TRIM
It cleans up the excess gaps in the text.

GERMANY (A1)


Four. Operators and Direct Expressions
In addition, directly mathematical and logical operators can be used in the cells:

Arithmetic Operators: Collecting (+), Extraction (-), Multiplication (*), Partition (/), Baseing (o), Mode (%).

Example: =A1 + B1*2


Text Merge Operator (&):

Example: =A1 & " " & B1


Comparison Operators: ==, ! =, >, n, >=, n=.

Example: =A1 >=50



And in addition to pluget tables you also do .cltf .md .json .sql has export custom, and there is also the import feature in .cltf format