Information
TYPE
Returns a number specifying the type of the given value. Syntax TYPE(value) value: The value given as input. E.g. TRUE 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 - ...
NA
Returns the #N/A error value. Syntax NA() Remarks The value #N/A! can be directly used in the cell instead of =NA() too. Examples Formula Result =NA() #N/A! Get a hands-on experience of the function in the embedded range below. Possible ...
N
Returns the numeric value of a given argument. Syntax N(value) value: Number, text, or logical expression whose numeric value you want. N returns 0 for text, 1 for TRUE, and 0 for FALSE values. E.g. "Zoho" Examples Formula Result =N("Zoho") 0 ...
ISTEXT
Returns TRUE if the given value is or refers to text, and FALSE otherwise. Syntax ISTEXT(value) value: The value to test. E.g. "Zoho" Examples Formula Result =ISTEXT("Zoho") TRUE =ISTEXT(A3) FALSE =ISTEXT(A4) FALSE Get a hands-on experience ...
ISREF
Returns TRUE if the given value is a reference to a cell or range of cells, and FALSE otherwise. Syntax ISREF(value) value: The value to test. E.g. A7 Remarks ISREF function returns TRUE for defined names as well. Examples Formula Result ...
ISODD
Returns TRUE if the given value is an odd number, and FALSE otherwise. Ignores decimal digits and negative signs. Syntax ISODD(value) value: The value to test. E.g. 1 Examples Formula Result =ISODD(1) TRUE =ISODD(A3) TRUE =ISODD(A4) FALSE Get ...
ISNUMBER
Returns TRUE if the given value is a number or a logical value, and FALSE otherwise. Syntax ISNUMBER(value) value: The value to test. E.g. 12 Examples Formula Result =ISNUMBER(12) TRUE =ISNUMBER(A3) FALSE =ISNUMBER(A4) FALSE Get a hands-on ...
ISNONTEXT
Returns FALSE if the given value is or refers to text, and TRUE otherwise. Syntax ISNONTEXT(value) value: The value to test. E.g. A2 Examples Formula Result =ISNONTEXT(A2) FALSE =ISNONTEXT(A3) TRUE =ISNONTEXT(A4) TRUE Get a hands-on ...
ISNA
Returns TRUE if the given value is or refers to the #N/A! (Not Available) error, and FALSE otherwise. Syntax ISNA(value) value: The value to test. E.g. A2 Examples Formula Result =ISNA(A2) TRUE =ISNA(A3) FALSE =ISNA(A4) FALSE Get a hands-on ...
ISLOGICAL
Returns TRUE if the given value is either TRUE or FALSE, and FALSE otherwise. Syntax ISLOGICAL(value) value: The value to test. E.g. FALSE Examples Formula Result =ISLOGICAL(A2) TRUE =ISLOGICAL(A3) TRUE =ISLOGICAL(A4) FALSE Get a hands-on ...
ISFORMULA
Returns TRUE if the given cell contains a formula, and FALSE otherwise. Syntax ISFORMULA(cell) cell: The cell reference to test. E.g. A2 Examples Formula Result =ISFORMULA(A2) TRUE =ISFORMULA(A3) FALSE =ISFORMULA(A4) TRUE Get a hands-on ...
ISEVEN
Returns TRUE if the value is an even number, and FALSE otherwise. Syntax ISEVEN(value) value: The value to evaluate. Signs and decimal numbers are ignored. E.g. 2 Examples Formula Result =ISEVEN(2) TRUE =ISEVEN(3) FALSE =ISEVEN(-4) TRUE Get a ...
ISERROR
Returns TRUE if the value refers to an error value, and FALSE otherwise. Syntax ISERROR(value) value: The cell reference with the value to test. E.g. A2 Examples Formula Result =ISERROR(A2) FALSE =ISERROR(A3) TRUE =ISERROR(A4) TRUE Get a ...
ISERR
Returns TRUE if the value refers to an error value other than #N/A!, and FALSE otherwise. Syntax ISERR(value) value: The cell reference with the value to evaluate. E.g. A2 Examples Formula Result =ISERR(A2) TRUE =ISERR(A3) TRUE =ISERR(A4) ...
ISBLANK
Returns TRUE if a cell is blank/empty, and FALSE otherwise. Syntax ISBLANK(cell) cell: The cell reference to test. E.g. A2 Examples Formula Result =ISBLANK(A2) FALSE =ISBLANK(A3) TRUE =ISBLANK(A4) TRUE Get a hands-on experience of the ...
FORMULA
Returns the formula present in a cell as a text string. Syntax FORMULA(cell) cell: The reference of cell containing the formula. E.g. A2 Examples Formula Result =FORMULA(A2) =SUM(F1:F5) =FORMULA(A3) =TODAY() =FORMULA(A4) =CELL("WIDTH") Get ...
CURRENT
Returns the current (to date) result of a formula. It can be used in combination with other functions. For example, the function =2+3+CURRENT() returns 10 as the result. Syntax CURRENT() Examples Formula Result ="co"&CURRENT() coco ...
CELL
Returns information about the address, format, or content of a given cell. Syntax CELL(info_type; cell_ref ) info_type: Text string that determines which information to return. E.g. "WIDTH" cell_ref: The reference of the cell whose information ...

Access your files securely from anywhere

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.