TYPE
Returns a number specifying the type of the given value.
Syntax
TYPE function returns:
1 - if value is a number
2 - if value is a text
4 - if value is a boolean
16 - if value is an error
64 - if value is an array
Examples
|
Formula |
Result |
|
=TYPE(TRUE) |
4 |
|
=TYPE({4,3,2}) |
64 |
|
=TYPE("Zoho") |
2 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Similar Functions
-
ERRORTYPE
-
ISERROR
-
ISLOGICAL
-
ISNUMBER
-
ISTEXT
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Sync live data from webpages to the spreadsheet
To link external data: Click Data > Link External Data. From the dialogue box, choose the type of data you want to link the spreadsheet to. Set the location where the external data is to be placed in the spreadsheet. By default, it is set to the ...INDIRECT
Returns a cell reference, given a text string. The obtained reference is evaluated and the function finally returns the cell value. Syntax INDIRECT(text_ref; [ref_type]) text_ref: The string that represents the cell reference to evaluate. E.g. D3 ...Insert a note
To insert a note: Tap the desired cell on which you wish to insert the note. Go to icon Under the Insert menu, choose Note. Type in the desired content for the note and tap on ✓.Notify all the collaborators in a sheet
To notify collaborators: Click Share > Notify collaborators. Use Notify Collaborators present within Share option In the message dialog that appears, type in your content and click Send. All the collaborators will receive an email with your ...TTEST
Returns the probability associated with a T-test. Calculates the likelihood that two samples have come from the same two underlying populations having the same mean. Syntax TTEST(data1; data2; mode; type) data1: The first array or data range. ...