Introduction
You can create conditions using an structure like this
if(comparison)
{
return value
}
or if you prefer you can use a shorter structure like this:
if(comparison)
value
Replace “comparison” with the comparison you want and “value” with the value that need to be used, example:
You can use multiple if conditions in the formula, like in this example
Type of comparissons
You can use these comparisons
Comparison | Name | Example |
> | Greater than | if(10>20) |
>= | Greater or equal than | if(10>=20) |
< | Less than | if(10<20) |
<= | Less or equal than | if(10<=20) |
== | Equal to | if(10==20) |
!= | Not equal to | if(10!=20) |
contains | Contains | if(“Hello word” contains “word”) |
not contains | Not Contains | if(“Hello word” not contains “word”) |
31
AUG
2021
AUG
2021
About the Author:
Im programmer working for an international company. I have programmed since i was 12 and i have done it professionally for 6 years. Programming for a company is fun and i have learned a lot of things but i have always been interested in running my own business so i decided to give it a shot doing what i do best, programming stuffs.