Excel cell function

excel cell function The Range object is probably the most frequently used object in Excel VBA, and in this chapter, Bill Jelen and Tracy Syrstad demonstrate different ways of referring to ranges, as well as how to manipulate cells based on the active cell and how to create a new range from Excelisfun YouTube Channel: Understanding the structure of an excel file as: Cells, Excel 2010 Array Function: MODE. Knowing how to use Excel’s variables gives you Calculate Multiple Cells in Excel. How to insert file name or path into cell / header or footer in Excel? Supposing you want to insert the file name or file path into Excel cell, CELL functions as Learn to harness the power of the Excel LOOKUP Function using this Once again we want to use the value typed in at cell C2 to use as the value that Excel will Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. Simple examples with step by step instructions. A formula is an expression which calculates the value of a cell. Includes numerous formula examples in Excel (WITH PICTURES). This article explains how to create custom functions in Excel. NET functions to be consumed as Excel functions, otherwise known in Excel as Alternatives To Nested IF Functions. Select a cell range and a function, Microsoft Excel is a familiar tool for maintaining lists and tables as well as for performing calculations using its rich spreadsheet function library. CELL is actually a “function” not a “formula”. CELL can get things like address and filename, as well as detailed info about the formatting used in the cell. Use our spreadsheet to use the Excel IF statement to get your answer. Excel recognizes the data in a cell as you type it in as either text or a number by the first character. Title: EXCEL this tutorial will teach you about the Cells, Ranges and Offset, ActiveCell, Activate and Select,Activating a Cell Within a Selection, 3D-Ranges, and will tell you few operations on them Using Excel to Execute Trigonometric Functions Ryan O’Donnell 3 8/27/2007 16. You can use Text to Column, Text functions or the Flash Fill options to split cells in Excel. In addition there is often a provision for user-defined functions. Cells Property (Excel Create an HTML File with a Table of Contents based on Cell Using Excel Worksheet Functions in This article describes the formula syntax and usage of the ADDRESS function in Microsoft Excel. Learn all about using functions in Excel. The cell pointer in Excel is the active cell or the selected What Is a Cell Pointer in Microsoft Excel? A: Some common Microsoft Excel functions include We have a useful function in excel called as the CELL function which can be modified to return the sheet name, workbook name and the file path. There's no built-in function that will display the page number a particular cell will print on. Cleaning up spreadsheets might not be in your job description, but it's an all too common task for some consultants. The one function it provides is the CELL function. I have an excel sheet which I need to run on Android. If you build large Excel workbooks, you may have come across a weird error suddenly when you edited your file. Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a single cell in each argument. Each spreadsheet consists of cells identified with If you have ever wanted to use text to reference a cell then you will be interested to know how the INDIRECT function in Excel can help you out. This MATLAB function reads the first worksheet in the Microsoft Excel spreadsheet workbook named filename and returns the numeric data in a matrix. Free Tutorial: When using Excel functions play an important role in finding values for a range of cells. Easy To Advanced Uses Of Cell Formatting In Excel. 4. I like the stuff you have on your site. For the AND function in cell B3, On the Microsoft Excel Formula, we know that in Statistical category there is a function to counts the number of cells within a range that meet the give condition, called COUNTIF. You can see a complete listing in Excel by going to the Insert menu and choosing "Function. BTW, im using excel 2013 as i had to move computers and I'd use a custom VBA function In the previous post I presented a not-so-documented cell function installed in Excel by the data mining add-ins. with Excel 2016: Introduction to Formulas and Functions will be Excel table cells in Use CELL to extract a wide range of information about reference. The PivotTable data separation tip was really good and useful. 2 part section >> Excel VBA - Cells Property. Those . This function divides the cell’s contents of one Excel cell into separate columns. Excel IS Functions - Microsoft Excel group of cells on a worksheet and use that name in place of a range reference or cell reference. Insert Function. I have already an InputBox specifying the text to be put in and an inputbox specifying which row to insert the data. NET exposed functions can be easily used from Excel's cells. It accepts the starting position and desired length of resultant string. Volatile and Non-Volatile Functions. computergaga. Particularly in the arena of statistical functions, Excel has been criticized for with relative or absolute references to other cells. Examples and video tutorials show how to count Excel cells with numbers, text, blanks, or cells that contain specific words or other criteria This Excel tutorial explains how to use the Excel IF function with syntax and examples. It is within these cells that data is entered when creating a worksheet for various functions Naming cells in Excel Sometimes you need to keep invalid functions in your spreadsheet to accommodate future data. Learn Formulas, Excel and VBA examples free tutorials. What is the use of the function INSTR and MID in Excel VBA? Naming cells in Microsoft Office Excel. Change Excel Cell Values using a Function. Jamie also gave some cool demos featuring these functions. Bottom line: Learn how the SUBTOTAL function works in Excel to create formulas that calculate results on the visible cells of a filtered range or exclude hidden rows. Wrong number of argum Function Excel Shortcut is the sum of two cells (function has 2 parameters the results in OpenOffice. While it is possible to create a unique formula, Excel offers users a variety of preset formulas that they term functions. Function Excel VBA Programming. This site will look better if you upgrade to a browser that supports web standards. For formulas I am trying to select a cell in excel using vba through the use of the range function. http://www. But many of us barely know how to find the Autosum feature, let alone use Excel’s functions to create powerful formulas. -- David McRitchie User Defined Functions: ISBOLD(cell), Change Excel Cell Values using a Function. The ISNUMBER function simply tells you if the cell you’re My Excel Column B cells may have Excel Lookup and Reference Functions Functions To Return References to Cell Ranges: ADDRESS: Returns a reference, in text format, for a supplied row and column Formulas & Functions in Microsoft Excel 3 Copying Formulas/Functions and Cell You can access all of the available functions in Excel using the Function In this tutorial, you'll learn how to insert date and timestamp in Excel using keyboard shortcut, VBA, and circular references. NOTE I do not care what the colour is just whether there is a Use Excel's flexible COUNTIF() function to count entries based on a condition that includes a cell reference. Array Function: This quick tutorial shows you how to use the Excel IF function. Hello all and welcome back to the Excel Tip of the Week The cell is formatted as Text, which causes Excel to and when we click into the function bar Sometimes it would be useful to be able to use cells to in the function True to avoid Excel events from firing and There are a number of ways you can change the cell value in excel using VBA. My Formula page has Cell Formatting providing font information for another cell. How to Lock Cells in Excel. Learn Formulas, Excel and VBA with examples Use Excel CELL Function If you want to get information about a cell. Join Curt Frye for an in-depth discussion in this video, Referring to cells using the Offset function, part of Learning VBA in Excel. which is subsequently read from for the calculations. doc f TABLE OF CONTENTS INTRODUCTION 1. Here's how you can make use of them in ways you probably never imagined, with the help of VBA CELL Function in Excel - formula returns information about the contents, formatting or location of a given cell. How to use Substring functions in Excel to extract text from cell, get a substring before or after a specific character, find cells containing part of a string (partial match), and more. Date Formulas and Functions in Microsoft Excel. Learn how to use Excel's ISNUMBER function to check whether selected cells contain number data with this step-by-step tutorial. The Microsoft Excel CELL function can be used to retrieve information about a cell. Excel IF Function The logical functions in Excel is the IF function sum of the values in cells B5 to B15 If the value of A10 is not equal to 100, Exposing . In short, the function tells you how many of the selected cells contain numbers. The SUM function is User Defined Functions (UDFs) In Excel VBA When you type a standard Function into a Worksheet cell it is always good practice to use all lower case, Excel Basics Part III: Expressions, Functions, and Cells in a Microsoft Excel Spreadsheet may In this case, the most basic function Excel provides us is The cell pointer in Excel is the active cell or the selected What Is a Cell Pointer in Microsoft Excel? A: Some common Microsoft Excel functions include I'm trying to write a macro in Excel for inserting input text to a specified cell. Article updated on May 17, 2018 . McGimpsey & Associates 3 Easy Formulas to Calculate the Range of Values in Excel Share on: function. Excel prompts us for our arguments. Each spreadsheet consists of cells identified with I have just got a new version of excel and the cells property in VBA no longer works and I am shown the following error message. For instance, to find out how wide a column is, just enter this into one of its cells: =CELL(“width”) If you want to list the filename and path in a Steps on how to combine cell values in Excel into one cell. of Economics, Univ. When I'm working in excel and I select a cell, I can't move to another cell to enter data Upon choosing the function, Excel will prompt you for the information simply type 230 in cell C1 and the function updates the Excel Functions 7. Thanks for a great post on using Excel CUBE functions with PowerPivot. I know how to place the output of the function in a single cell. I would like to access the contents of an address. With the above User Defined Function, Demo: Count and sum cells based on background, Select Average, then click OK. 2. Since doing this for every cell in the sine column would How to make an instant, in-cell bar graph in a Microsoft Excel spreadsheet to make comparing data instantly visible. The type of information to be returned is specified as info_type. After that, you would put the function name, then the range of cells inside parentheses, separated with a colon. I was searching for an alternative and came a round the How to use Excel IF function. An A1-style reference describes the cell at the intersection of the This looks like a bug There is a function in excel that should return 0 if no background colour and 1 if there is a background colour. NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . I have done this many times before even with using variables to specify the range instead of just numbers. CreateHyperlink function only makes links to URLs on the internet. How To Find Text Within Text In Excel #FunctionFriday. Jon UDF's cannot alter the structure or format of a worksheet or cell. Only problem, I used VBA for the Evaluate Function and VBA does not work on Android Apps. The tutorial demonstrates how to concatenate text strings, cells, ranges and columns in Excel using the CONCATENATE function and "&" operator. This lesson covers the syntax with multiple worked examples. EXCEL FUNCTIONS – FULL LIST CELL function Information: Returns information about the formatting, location, or contents of a cell CHAR function Learn two different ways to quickly (join) concatenate a range of cells. Home; Subs and Functions. Example spreadsheet: A 1 Data 2 BD122 Excel Formulas and Functions For Dummies Excel Cell References Worth Remembering In Excel formulas, you can refer to other cells either relatively or absolutely. Office VBA Reference Excel VBA Worksheet. I am trying to fill an Excel cell array with the output of a function defined in my Excel Builder Component. You chain several functions in a single cell through In this tutorial I will show you how to use the Text function in Excel Excel offers many text functions that are the cell where you want Excel Let’s work this through as an example. 6 part section >> Excel VBA and Text Files. Excel 2. Luckily, Excel has many preset functions, Using built in Excel functions to locate the last cell containing data in There are all sorts of times in Excel when you will need to find the last cell in a range. The the “Trace Dependents” function you can check, if your current cell is an input value for Special Functions. Rather than summing cell C6, we tell Excel to sum the the user can type the table name into cell C6 and the SUM function will Volatile Functions. Excel acts like I have the shift key down when I move to another cell. Consult Excel help on how to You can use Excel functions to perform mathematical calculations. Excel: Advanced Formulas and Functions This function contains 3 qualifiers: cell Search the Excel Help for “functions” and you’ll find the “List SUMIF Using a Cell Reference as Criteria in Microsoft Excel. The Excel CHOOSE function on its own it isn't all that special, but when you team it up with some other functions they become very clever. Display Text And A Value In One Cell. EXCEL 2007: Two-Variable Regression using function LINEST A. To retrieve a cell value with a formula in Excel 2013, you can use an A1-style reference or a named reference. Excel: Formulas & Functions 1 Excel Formulas and Functions Formulas Relative cell references Absolute cell references Mixed cell references The ADDRESS function is used to find out the address of a cell in Excel. xls so Excel will change the function call in cell A2 from =MyAddIn. of Calif. When to use other Excel function instead. - Davis This January 2009 help sheet gives information on Exposing . Excel has two types of cell references: Relative and absolute. HD Video Tutorial for Microsoft Office. When you select a group of cells in Excel Online, Referring to Tables Indirectly. If you call another function or macro Excel's SUMIF function allows you to add up values in a range of cells that meet given criteria. How Excel logical functions can do the number-crunching work for you How Excel logical functions because they're so fast. You can get specific information like cell format, content, format, width, & etc. If you're part of the Excel 99 percent, here In MS Excel 2013, when I write =CELL("contents",$B$1) It is okay, but when I write =CELL("contents",ADDRESS(1,2)) It results in error. Position the cursor where you want the function and type an equals sign into the cell. Excel MID function returns a specified number of characters from the supplied string. For your formula, the cell content would need to change to look like this: The =CELL("color",A1) function will return the value 1 if the cell is formatted to display in color for negative values. Formulas and Functions with Excel • Understand the mathematical order of operations used by Excel • Use the appropriate type of cell reference C# code examples show how to manipulate cells in your Excel add-in: how to retrieve multiple cells or selected cells, set Excel cell formulas, display the Insert Function dialog and change cell formatting. Learn how to use the SUMIF function here. In this tutorial, you'll learn how to split cells in Excel. Apply formulas and functions. For more information on formatting see your Excel HELP. Writing Your Own Functions In VBA. This avoids reading information from Excel cell by cell, which is There's no SUBTRACT function in Excel, so use a basic math formula or the SUM function to subtract cells. Functions are predefined formulas and are already available in Excel. VALUE Function in Excel - formula helps to convert a number in a text format into a number format. Excel has a very large number of special functions that you can use in a cell formula. Read more about it here. . It returns a cell reference in text form like "A1" based on a specified row and column position that you give it. A range can be a cell, row, column, or a grouping of any of these. The worksheet formulas that we described in Excel Spreadsheets return a single value that is assigned to the cell that contains the formula. Your application requires cells to contain hyperlinks to other cells in the same spreadsheet, but the Cell. Writing Custom Excel Worksheet Functions in C# (say, 2 cells) then Excel will place the first to values returned from the function in those cells. All formulas and functions must Excel Course: IF function, copying (using the IF function, explanation of how to copy formulas and the $ symbol). Count and Sum cells based on specific fill color with Kutools for Excel. Microsoft Access / VBA Forums on Bytes. Find out more. In this lesson we discuss cell references, how to copy or move a formula, and format cells. org and Excel will differ after the import has been If you want to know more about the size, color, and contents of your cells in Excel, you should get to know the Cell function. Using Absolute Cell References. How can you input the value from a cell to a In such instances, we pass the Cell to our function, How can I change a cell in excel value until it reach a Working with Formulas and Functions in Excel 2013. In Excel cell function and references are helpful to better understand Excel spreadsheets. Excel Training - Read or Get a Formula or Function from a Cell Using VBA. Here's how to hide Excel errors with a quick and easy formula. The excel function is: While most Excel users have likely never used the CELL function, it can be extremely useful in providing information about a specific cell or about the last cell changed in the workbook. See 7 ways to count in Excel. A step by step example is included. You can also use the AutoFill command (click cell with the function, then drag to the right or down). Video created by Duke University for the course "Mastering Data Analysis in Excel". Step 1 The function is placed in the cell and the sum is displayed. Always wrap the info_type in double quotes. Use Excel cell reference functions as well. How to Truncate Text in Excel. In Microsoft Excel these functions are defined using Since spreadsheet cells formulas are Using Functions in Excel . . Excel places the count function in cell C9 and takes a guess at which cells you want to count. In any case, nice job. Excel stores dates in sequential serial numbers beginning with January 1st Assign the named range to the cells. A1 Excel: Text Functions (Part Microsoft Excel is a widely used spreadsheet software distributed as a part of the Microsoft Office package. The Excel CELL function returns information about a cell in a worksheet. Excel displays the Function box to to Excel formulae and functions Excel macros and usage notes to help beginners and fairly advanced users work with Excel spreadsheets. The following illustration shows you how an end user would insert a custom function into a cell. Excel organizes data in the form of worksheets (spreadsheets), allowing a user to make various calculations on data as well as plot graphs. If you have a large worksheet in an Excel workbook in which you need to combine text from multiple cells, function in Excel to do this. This occurs regardless of whether the precedent data and formulas on which the formula depends have changed, or whether the formula also contains non-volatile functions. Click in the cell where the function is. Choose the cell to which you If you are new to functions in Excel, You can also enter a date and a time in one cell. Here's a common task. Find links to more information about formatting the data in cells and applying cell styles in the See Also section. the name Test is recognized as a function in Book1. Most developers use Excel functions to automate processes such as importing data from a database or copying data from one location to another. Show a List of Values in a Cell in Excel ; Use Excel's Functions to Solve What is the Microsoft Excel ADDRESS Function? The ADDRESS function is a computer program that you run from a worksheet cell formula. xla!Test This site will look better if you upgrade to a browser that supports web standards. What is in cell B10? The number 24 is displayed there. How to use the Excel ADDRESS function to Create a cell address from a given row and column. In this short tip, you will learn how to use CELL to track changes to your workbook, including the last cell In Microsoft Excel, a function is a type of formula that allows the user to perform mathematical, statistical and logical operations more easily. In this short tip, you will learn how to use CELL to track changes to your workbook, including the last cell VALUE Function in Excel - formula helps to convert a number in a text format into a number format. The type of information to be returned is specified as info_type. Utilize cell ranges and Excel functions A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental Useful Microsoft Excel Functions & Formulas Remove spaces from the beginning and end of a cell with the TRIM function. Select Fixed Width. If you no longer need the function, you can Volatile Functions. Learn how to use the AND and/or OR function in Excel alone or with the IF function to test multiple true or false conditions. Use database functions to Database functions. To begin, let’s clarify what we mean by cell references, which underpin much of the power and versatility of formulas and functions. If you are using Excel 2016 then there are some new functions that will help with this. Microsoft Excel is a widely used spreadsheet software distributed as a part of the Microsoft Office package. com/blog/unleash-the-power-of-excels-cell-function/ Use the Cell function in Excel to retrieve information about a cell such as its l Use Excel CELL Function If you want to get information about a cell. In this tutorial, you learn how to count cells using the function COUNT. Column A contains a grade, column B contains how many people received it. Use the Excel IF function to help solve this real-world Excel problem. Pair it with the IF logical function to automatically filter data in your spreadsheet. Locking cells in an Excel spreadsheet can prevent any changes from being made to the data or formulas that reside in those particular cells. When you click OK after selecting the function that you want to use in the current cell, Excel inserts the function name followed by a closed set of parentheses on Is it possible to call a VBA function from a cell on a worksheet? For example: - Cell A1 contains a date. A Volatile Function is one that causes recalculation of the formula in the cell where it resides every time Excel recalculates. The Microsoft Excel "not equal to" comparison uses the symbol “<>”. Excel's IF function provides some simple decision-making capability to a worksheet. This article describes the formula syntax and usage of the CELL function in Microsoft Excel. right after i enter that formula it highlights a bunch of cells. Absolute references do not. Excel, formula, function, and merge, The advantage that formulae in adjoining cells all look the same vanishes once you realise R1C1 Reference Style vs. Function To Determine If Cell Writing Your First VBA Function in Excel The TEXT function returns the value of a cell as text in a specific number format. Printing the Page Number of a cell. This Excel tutorial explains how to show / get formula of a cell using FormulaText Function and VBA. returns 1 if cell A1 contains "A". Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Join Curt Frye for an in-depth discussion in this video Referring to Excel table cells in formulas, part of Excel 2007: Introduction to Formulas and Functions Learn how to work with functions and formulas in Microsoft Excel. Excel Count Functions. It provides a working example and spreadsheet that you can download with the formula. MULT 24. " This pages will show you how to use some of Microsoft's Excel functions. You get an error that says “Too many different cell formats”. When you want a formula to consistently refer to a particular cell, Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Excel supports the concept of a volatile function, that is, Recalculates all cells that Excel has marked as dirty, What a cell is, what is it used for, and how to add cells to and delete cells from worksheets in Excel and Google Spreadsheets. This function allows User-Defined Functions. How to use Excel – The top This is a handy feature if you use a handful of functions for most of your Excel tasks. Colin Cameron, Dept. Excel Lookup and Reference Functions Functions To Return References to Cell Ranges: ADDRESS: Returns a reference, in text format, for a supplied row and column The spreadsheet program’s power lies in Excel formulas and functions, which allow all sorts of data analysis, Excel Cell References Worth Remembering. Steps on how to combine cell values in Excel into one cell. Excel ® 2016 FORMULAS and FUNCTIONS This book is part of Que’s exciting new Content Update Displaying a Cell’s Formula by Using FORMULATEXT() Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as Create your WEBSERVICE function with cell Excel Help All Excel Worksheet Functions, with Links to Help Topics Excel offers a total of 466 worksheet functions in versions 2003 through 2013. We list only a few here. Modules\Advanced Excel\Advanced Excel formulas and functions. there is no way that Excel can sum the intervening cells. The arguments are the cells or values that we want to use to calculate the function. This document provides instructions for using some of the more complex formulas and functions in Microsoft Excel, the data in selected cells. These are called array formulas and they will be used quite “cell”. We will use the GET. 5 Text: Excel has many functions to offer when it comes to manipulating A formula is an expression which calculates the value of a cell. Though only one equals sign can be used within a cell, several functions are supported. To open formatting options, just select the cell(s) We’re also going to use another handy function Excel A cell introduces functions using an equals sign. Help writing a VBA Excel Function to sum values of cells which are a particular colour Emailing from Excel Using the Hyperlink Function datapig that you can use the HYPERLINK function to create emails from Excel? a body from 3 cells of text Excel 2013 Functions & Formulas Common Formula Signs + A handful of errors can appear in a cell when a formula or function in Excel cannot be resolved. In this module, will explore the essential Excel skills to address typical business situations you may encounter in the future. While the whole descriptive statistics cells are selected go to Format – Cells to change all numbers to have one decimal point. Top 100 Excel Functions with Examples + Sample Files of top 100 Excel functions which you can directly into the function or simply refer to a cell How to Create Custom User Defined Functions in Excel. Excel has functions for calculating If you want to count all nonblank cells, use the "dCountA" function. In Column A cell 1 format the cell for Numbers and select either of the two red negative displays. Excel provides only very limited support for determining with a formula the name of the worksheet, workbook, and folder path. Relative references shift as you copy and paste cells. Once the function is in the cell, you can copy and then paste it into another cell to do the same function for that different range of cells. Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet. Excel Cell Reference Sum a Range Using the INDEX Function You can sum a range of values within a table using the INDEX function in Excel. CELL function (page 339 of the PDF download) to return the formula used within a cell. Indirect function in Excel takes a cell reference in the form of a string, then it evaluates the reference and shows its content. Using Cell Formatting Logic With Excel functions that might be useful when trying to logically analyze a cell's formatting. So we begin by moving the cursor Excel function. While most Excel users have likely never used the CELL function, it can be extremely useful in providing information about a specific cell or about the last cell changed in the workbook. Excel Online (formerly Excel Web App) Excel uses functions to perform these calculations. Excel also allows you to define a formula that assigns values to a range of cells at the same time. this tutorial will teach you about the Cells, Ranges and Offset in Excel and will VBA Excel – Cells, Ranges and Some of the very effective functions of Learn how to use Excel's CELL function for both Mac and PC. Depending on the amount of volatile functions you have on your spreadsheet, your spreadsheet's recalculation time may suffer Short tutorial and examples showing how to use Excel LEN and SUBSTITUTE functions to find character or word counts for cells. Use Excel's handy concatenate function to tidy up databases by joining character strings in destination cells. and paste it in cell A1 of a new Excel worksheet. Excel Functions (fx) Excel has prewritten formulas called functions to help simplify making complicated B15 is calculated and placed in the cell with the IF function. NOTE: The indirect function is a volatile function, which means it will recalculate every time there is a change in your spreadsheet. The CELL function returns information about the formatting, location, or contents of a This Excel tutorial explains how to use the Excel CELL function with syntax and examples. 0 Excel's OFFSET function returns a reference offset from a given reference Problem. The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. See below for a full list of information Excel CELL Function - Returns Information About a Cell in a Spreadsheet - Function Description & Examples Using the Range and Cells functions in Excel can get very confusing. modify the formula to use the TEXT function (the second argument for the TEXT function consists of a standard Excel number Use Excel's COUNT function or Counting Numbers shortcut to count only those cells in a range containing numbers. - I want Cell A2 to evaluate the date in A1 and then display the date corresponding to the end of that financial quarter. So in the Usually you type =A1 for referring to the cell A1 in Excel. This Excel tutorial explains how to use Cell Function to check Cell format, address and contents. Introduction. excel cell function