Arithmetic operator
|
Meaning
|
Example
|
+ (plus sign)
|
Addition
|
3+3
|
– (minus sign)
|
Subtraction
Negation |
3–1
–1 |
* (asterisk)
|
Multiplication
|
3*3
|
/ (forward slash)
|
Division
|
3/3
|
% (percent sign)
|
Percent
|
20%
|
^ (caret)
|
Exponentiation
|
3^2
|
Comparison operator
|
Meaning
|
Example
|
= (equal sign)
|
Equal to
|
A1=B1
|
> (greater than sign)
|
Greater than
|
A1>B1
|
< (less than sign)
|
Less than
|
A1<B1
|
>= (greater than or equal to sign)
|
Greater than or equal to
|
A1>=B1
|
<= (less than or equal to sign)
|
Less than or equal to
|
A1<=B1
|
<> (not equal to sign)
|
Not equal to
|
A1<>B1
|
Text operator
|
Meaning
|
Example
|
& (ampersand)
|
Connects, or concatenates, two values to produce one continuous text value
|
("North"&"wind")
|
Reference operator
|
Meaning
|
Example
|
: (colon)
|
Range operator, which produces one reference to all the cells between two references, including the two references
|
B5:B15
|
, (comma)
|
Union operator, which combines multiple references into one reference
|
SUM(B5:B15,D5:D15)
|
(space)
|
Intersection operator, which produces on reference to cells common to the two references
|
| Data type | Length | Description |
|---|---|---|
| BYTE | 1 byte | Number from 0 to 255 for storing binary data |
| INTEGER | 2 | Integer from -32 768 to 32 767. |
| LONG | 4 | Integer from -2 147 483 648 to 2 147 483 647 |
| SINGLE | 4 | Numeric data type with float precision to 6 decimal digits |
| DOUBLE | 8 | Numeric data type with float precision with double precision in calculatons |
| CURRENCY | 8 | A number with fixed 4 decimal digits |
| DECIMAL | 14 | Numeric data type with fixed precision and scale (precision 28). |
| STRING | Text strings. Flexible lenght or 64 kilobytes | |
| BOOLEAN | 2 | Logical value (true or false) |
| DATE | 8 | The date in range from 1.1.100 to 31.12.9999 |
| OBJECT | 4 | Reference to an object. |
| VARIANT | 16 | Basic type. May contain special value Null, any numeric value, text, reference to object or variable array. |
Now days whatsapp is too popular one of the billion people using WhatsApp every day. It has been a primary mode of communication for almost everyone. Mostly people don't know how to add Bold, Italics, and Strikethrough text on whatsapp. Like all other features of the app, this too is quite simple to use. Just read below steps for make Bold, Italics, and Strikethrough text on whatsapp.
In title:- How to Type Bold, Italics, and Strikethrough in WhatsApp
A virtual private network (VPN) is a network that is constructed using public wires — usually the Internet — to connect to a private network, such as a company's internal network. There are a number of systems that enable you to create networks using the Internet as the medium for transporting data.
You are new on blogspot /blogger? You want to add menu on your blogspot /blogger? So don't worry here you read How to make menu bar in blogspot /blogger. So just read this post carefully.
Avast Antivirus Is The Best antivirus software for malware blocking. Many users are using this antivirus in his/her mobiles or in PC or on tabs. So in this post you read How to Get 1 Year Avast Antivirus License Key For Free
Now days whatsApp is very useful in our daily life. We all know only admin of whatsapp group able to add any member in group but in this post you read How to Create Whatsapp Group Invite Link from GB Whatsapp easily for creating a whatsapp group link you need to install GBWhatsapp
Click Here to download GBWhatsapp
