Difference between revisions of "Manuals/calci/ISSTRING"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''ISSTRING( | + | <div style="font-size:30px">'''ISSTRING (thing)'''</div><br/> |
| − | *<math> | + | *<math>thing</math> is the value to test. |
| + | |||
| + | |||
==Description== | ==Description== | ||
*This function is one of the group in ISFUNCTIONS. | *This function is one of the group in ISFUNCTIONS. | ||
| Line 17: | Line 19: | ||
#=ISSTRING("123") = true | #=ISSTRING("123") = true | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=Bviec9utrKE|280|center|Is String}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:24, 7 March 2019
ISSTRING (thing)
- is the value to test.
is the value to test.
Description
- This function is one of the group in ISFUNCTIONS.
- The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-testing Functions.
- ISSTRING function can be used to check the given value is a string or not.
- This function gives the result as only TRUE or FALSE.
- The result is TRUE when the value is a string otherwise the result is FALSE..
- The argument can be blank, or it can contain data such as text,numbers,error values,logical values or any equations.
- When we giving any argument with in double quotes, this function will consider as the text.
value is a string otherwise the result is FALSE..Examples
- =ISSTRING('Good morning') = true
- =ISSTRING(123) = false
- =ISSTRING("") = true
- =ISSTRING(Good morning) = null
- =ISSTRING("123") = true